What would I have to do if B9=B14 are both equal but not with blank cells in each cell. If they both show nothing it returns "Paid" because the two blank cells match but I need it to have two matching numbers and then return "Paid"
Thanks
Code:
=IF(C2>0,C2,IF(B9=B14,"Paid",IF(B9>B14,"Over",IF(B9<B14,"Owe",IF(SUM(B9:B15)="","",IF(B21>0,"Inv",IF(SUM(B9:B15)="","",IF(B20>0,"Moving",IF(B19>0,"Meet",IF(B18>0,"Question",IF(B17>0,"Entered",IF(B16>0,"Plant"))))))))))))