| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using COUNTIF to search for existence | Excel Worksheet Functions | |||
| Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA | Excel Worksheet Functions | |||
| To Leave Cell blank Please | Excel Worksheet Functions | |||
| blank cell turns to 0 | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
