Forum Discussion
IF with multiple conditions please
I have a spreadsheet in which I have created a credit card statement. I have managed to get most functions to work but an IF function is puzzling me how to get around it and is not coming back with ...
Thank you for help gentlemen, I found the error and simplified the formula to just
=IFERROR(IF(L49>I49,L39,0),0)
it was cross calculating itself. Now seems to work perfectly.
The same could be written as
=IFERROR( (L49>I49)*L39, 0)
