Subtract or leave blank in cell
 

Hi all, how would I write this in cell G14

=E14-E13 if F14 cell has a number otherwise be blank

E F G
13 100 50 50
14 50 0


Thanks Stephen

Subtract or leave blank in cell
 

Try this:

=IF(ISNUMBER(F14),E14-E13,"")

Biff

"pano" wrote in message
oups.com...
Hi all, how would I write this in cell G14

=E14-E13 if F14 cell has a number otherwise be blank

E F G
13 100 50 50
14 50 0


Thanks Stephen