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
