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 the
neighbouring cell if another cell contains yes and to copy the amount
form the first cell if the second cell says no. I hope this makes
sense. You were all very helpful last time i posted a question so i
hope it works. Got to impress the boss!!!


--
Tilly
------------------------------------------------------------------------
Tilly's Profile: http://www.excelforum.com/member.php...o&userid=21809
View this thread: http://www.excelforum.com/showthread...hreadid=383838

Hai !
I need help this problem from yours.
How i can use conditional formating with IF, when i will comparison
value in cell others worksheets ?
Because it's case, am try, can not support in excel, why ?

As your help me , thanks. :)


--
Alwi
------------------------------------------------------------------------
Alwi's Profile: http://www.excelforum.com/member.php...o&userid=14208
View this thread: http://www.excelforum.com/showthread...hreadid=383838

Hi Tilly
try this,

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

HTH.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=383838

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

Replace@mailinator with @tiscali.co.uk


"greg7468" wrote in
message ...

Hi Tilly
try this,

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

HTH.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile:
http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=383838