If Function

T

Tilly

I want to put a sum in the "value if true".

What i want to achieve is that i add 10% to the value of th
neighbouring cell if another cell contains yes and to copy the amoun
form the first cell if the second cell says no. I hope this make
sense. You were all very helpful last time i posted a question so
hope it works. Got to impress the boss!!
 
S

Sandy Mann

Greg,

While your formula will return what the OP asked for, if B1 contains
anything but "yes" or "no" it will return FALSE because there is no false
value in the second IF like:

=IF(B1="yes",A1*1.1,IF(B1="no",A1,"Answer Yes or No only please"))

or if it is guarnteed that there will only be "Yes" or "No" in B1 then the
second If is not required:

=IF(B1="yes",A1*1.1,A1)

--
I know it's picky :)

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
 
Top