If Condition returns Formula

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

Quote:

---

Originally Posted by justdream

condition: C2<85
[value_if_true]: D2=C2+10
[value_if_false]: D2=C2+5

---

Code:

---

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

---

in D2

Code:

---

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

---

Very simple :-)
Perfect

you are welcome.

this a quick tutorial on IF function:

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