Multiple Conditions within an IF Function
Hey everyone,
Just wondering if anyone knows if it is possible to have the following style
of formula with two conditions before the true/false part eg.
IF(H2<=365 and F20,F2,"")
IF(H2<=365 condition 1, F20 condition 2,F2,"")
What I am trying to do is have a function which tests for two different
conditions before returning a value. So far I have not had much luck.
If anyone knows the best way to do this your help would be greatly
appreciated.
Cheers
|