Hello,
I’m thinking I need an ISERROR, IFERROR or Error.Type formula in front of my if statement, but I can’t seem to get it to work.
In cell K10 I have an if statement going to P3 and P4, basically whichever date is greater Add it to cell Q1 (which is just a number say 45). If there is only one date entered within J8:J13 than cell P4 will come up as #NUM!, which is ok. I just need my IF statement to recognize if it is #NUM! then only add P3 to Q1.
=IF(P3>P4,(P3+Q1),IF(P4>P3,(P4+Q1),P3+Q1))
Any help would be appreciated
Bookmarks