Forum Discussion
EXCEL IF FUNCTION
Hi, So, for example, =IF((H2="")*(J2=""),"",IF(H2>J2,"overload","apples")) this basically says if H2 or J2 are empty then return an empty string but if H2 is greater than J2 then return "overload" ...
Enter the values you want to return in cells, e.g in Y1 and Z1. You can then use
=IF(H2&J2="","",IF(H2>J2,$Y$1,$Z$1))
I don;t understand. What do you mean by "whatever the value of this string is"? What is "this string"?
Sorry! I've just now realized that your original solution works! My apologies. One question, if I may. As an old school type merchant - is there a good reference book for this sort of guidance? Years ago I liked to sit at the computer but look up stuff in a manual! I know it's all online these days but sometimes I just get it faster when I'm reading it on paper rather than 2 tabs open! I think it has to do with my age. Thanks again for your help.
See for example Excel 2019 Bible
- Thank you very much.