MrExcel Publishing
Your One Stop for Excel Tips & Solutions

IF function


Posted by julie brown on July 30, 2000 1:01 PM


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 Garry on July 31, 0100 1:33 AM

=IF(F6+G6<1,"",(H5-F6+G6))

try this...