MrExcel Publishing
Your One Stop for Excel Tips & Solutions

If function with multiple conditions


Posted by Julie on July 30, 2000 4:12 AM

Enter the if function in cell h6 that keeps this cell blank if cells f6 and g6 have no value, otherwise, add h5, subtract, f6 and add g6.


Posted by Ivan Moala on July 30, 0100 4:19 AM

=IF(AND(F6=0,G6=0),"",H5-F6+G6)


Ivan