What if?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mlv - 17 Sep 2007 12:14 GMT

I was looking at the formulas in some Excel 2003 workbooks and came across
some that began :

+IF

e.g. =+IF(K7>0,ROUND((K7*D$51/100),2),"")

I discovered that removing the '+' made no obvious difference. I also tried
searching the Help files, but couldn't find any reference to '+IF'.

What is the functional difference between 'IF' and '+IF', and where would
you use one in preference to the other?

Thanks

Signature

Mike
-Please remove 'safetycatch' from email address before firing off your
reply-

Reply to this Message

Bob Phillips - 17 Sep 2007 12:18 GMT

It is a Lotus throwback and is redundant.

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I was looking at the formulas in some Excel 2003 workbooks and came across
>some that began :
[quoted text clipped - 10 lines]
>
> Thanks

Reply to this Message

Rate this thread: