| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Blank
I am looking for a little assistance. If A2 is blank, then I want it
to be blank. If A2 is not blank then I use this formula: How do I add the if blank statement to this formula. =ROUNDDOWN(((TODAY()-C17)/365*12),0) Thanks in advance! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Blank
=if(a2="","",yourformula)
Debbie wrote: I am looking for a little assistance. If A2 is blank, then I want it to be blank. If A2 is not blank then I use this formula: How do I add the if blank statement to this formula. =ROUNDDOWN(((TODAY()-C17)/365*12),0) Thanks in advance! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Blank
On Oct 13, 7:56*pm, Dave Peterson wrote:
=if(a2="","",yourformula) Debbie wrote: I am looking for a little assistance. If A2 is blank, then I want it to be blank. If A2 is not blank then I use this formula: How do I add the if blank statement to this formula. =ROUNDDOWN(((TODAY()-C17)/365*12),0) Thanks in advance! -- Dave Peterson Thanks, with a little tweaking, I got with your help. Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting:highlight row based on blank or non-blank c | Excel Worksheet Functions | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| Excel 2002: Return blank when VLOOKUP on blank cells | Excel Discussion (Misc queries) | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
![Debbie[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
