PDA

View Full Version : [SOLVED] If Condition returns Formula



justdream
07-15-2014, 04:50 AM
Dears,

Kindly advice how to create If condition that returns formula in the position of "Value_If_true" & "Value_If_False"

My example:
Condition: C2<85
and to to return D2=C2+10 if true
and D2=C2+5 of False

mancubus
07-15-2014, 07:24 AM
condition: C2<85
[value_if_true]: D2=C2+10
[value_if_false]: D2=C2+5


=IF(condition,[value_if_true],[value_if_false])

in D2

=IF(C2<85,C2+10,C2+5)

justdream
07-15-2014, 08:07 AM
Very simple :-)
Perfect

mancubus
07-15-2014, 01:40 PM
you are welcome.

this a quick tutorial on IF function:

http://www.techonthenet.com/excel/formulas/if.php