If Blank - ExcelBanter

Posted to microsoft.public.excel.worksheet.functions

Debbie[_4_] Debbie[_4_] is offline

external usenet poster

Posts: 24

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
conditional formatting:highlight row based on blank or non-blank c	Nat Maxwell	Excel Worksheet Functions	3	May 14th 23 07:43 PM
Index/match - make blank cells return a blank value.	diaare	Excel Worksheet Functions	3	May 3rd 23 03:44 AM
Excel 2002: Return blank when VLOOKUP on blank cells	Mr. Low	Excel Discussion (Misc queries)	2	June 4th 09 05:12 PM
Average Formula to display blank cell if named range is blank	Rachael F	Excel Worksheet Functions	3	February 22nd 08 05:05 PM
Not showing blank and non blank items in filter mode for values	Bhaskar Polisetty	Excel Worksheet Functions	0	June 20th 06 02:04 PM

All times are GMT +1. The time now is 11:59 PM.

Menu

About Us