ExcelBanter - Subtract or leave blank in cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Subtract or leave blank in cell (https://www.excelbanter.com/excel-worksheet-functions/129952-subtract-leave-blank-cell.html)

pano

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

Teethless mama

Subtract or leave blank in cell

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

"pano" wrote:

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

All times are GMT +1. The time now is 10:40 AM.