- last edited on
I am using Excel 365. Using plain single sheet and cells A1 and B1. The formula is in C4 where I want the answer, Formula is IF(AND(A1=0,B1=0),0,0),IF(A1>B1,1,0). Always comes up with #VALUE error. I have made cell formats all numbers with one decimal place. I have tried making the values text "". It still comes up with #VALUE. I have separated the formula's and they both work fine stand alone. Using the tracer it goes correctly to the second formula and gives the correct result but still says #Value in C4????
03-12-2019 10:08 PM
Your formula is =IF();IF(). That is not a valid formula.
It should be:
A shorter way to achieve the same:
by MrStern on May 28, 2020
by ImogenR on May 28, 2020
by Muper Sega on May 28, 2020
by cuong on May 27, 2020
by Ingeborg Hawighorst on May 13, 2020