Formula

[Shona]

=IF(I6="",B2-F6,IF(F6="","",""))

Is there a way this could be changed so that if I6 and F6 are empty then
leave the cell blank.

Cheers
Shona

 

[Jason Morin]

Shona-

No need to post multiple times. You can use the AND
function:

=IF(AND(I6="",F6=""),"",IF(.....

HTH
Jason
Atlanta, GA