| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Blanks as a condition of a statement
How is it possible to do a function based on if a cell is
blank or not. Such as the following for cell a1: IF b1 is not blank then add b1-c1 else don't do anything in a1. I have tried but can't get anything to go. Thanks in advance, Lee |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Blanks as a condition of a statement
=IF(B1<"",B1-C1,"")
-- HTH RP (remove nothere from the email address if mailing direct) <Stuck on Blanks wrote in message news:4383062f.5bc.41@news2... How is it possible to do a function based on if a cell is blank or not. Such as the following for cell a1: IF b1 is not blank then add b1-c1 else don't do anything in a1. I have tried but can't get anything to go. Thanks in advance, Lee |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Blanks as a condition of a statement
Thanks, it worked very well. Again thank you.
Lee "Bob Phillips" wrote in message ... =IF(B1<"",B1-C1,"") -- HTH RP (remove nothere from the email address if mailing direct) <Stuck on Blanks wrote in message news:4383062f.5bc.41@news2... How is it possible to do a function based on if a cell is blank or not. Such as the following for cell a1: IF b1 is not blank then add b1-c1 else don't do anything in a1. I have tried but can't get anything to go. Thanks in advance, Lee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct - Blanks | Excel Worksheet Functions | |||
| Condition Statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
| linking files with blanks | Excel Discussion (Misc queries) | |||
Hybrid Mode
