Tuesday 6 May 2014

If Function/ If Formula Excel

If:
"Ifs" and "Buts" only call the satan and by using If, you can think of all satanically conditional work that can be done in excel.
It is simple and easy to use and the output is all the more pleasing. So let me hurry up with the syntax -
if(logical_test, [value_if_true], [value_if_false]) where,
logical_test - which is nothing but the condition

[value_if_true] - is optional and returns the decided value when the condition is met
[value_if_false]  - is optional and returns the decided value when the condition is not met  


0 comments:

Post a Comment