It does exactly that for me. I entered "abc" in cell E4, and the formula returned 0.However, sometimes E4 is not a number. On those I'd like the formula to return a 0. How is this done?
It does exactly that for me. I entered "abc" in cell E4, and the formula returned 0.
Can you provide an example of that is in cells E4, F4, and H4 when it does not return a 0, like you want?
Nope.I would say it will as it is!
Nope.
< and > operators consider text strings and logicals to be greater than numbers
If E4 is BLANK, then E4 is considered 0, therefor E4<20000 is TRUE = F4*H4*4.78
If E4 is TEXT (including formula blanks ""), then E4>20000 is TRUE = F4*H4*6.15
If E4 is a logical TRUE/FALSE then E4>20000 is TRUE = F4*H4*6.15
It does exactly that for me. I entered "abc" in cell E4, and the formula returned 0.
Can you provide an example of that is in cells E4, F4, and H4 when it does not return a 0, like you want?
Ah yes, the issue was I left F4 and H4 blank, which is why it was returning 0.Nope.
< and > operators consider text strings and logicals to be greater than numbers
If E4 is BLANK, then E4 is considered 0, therefor E4<20000 is TRUE = F4*H4*4.78
If E4 is TEXT (including formula blanks ""), then E4>20000 is TRUE = F4*H4*6.15
If E4 is a logical TRUE/FALSE then E4>20000 is TRUE = F4*H4*6.15