| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with formula
I am using =H4+30 where h4 is my date cell for my quote invoice but when h4
is blank I get 1/30/00 how can I make it show blank when h4 contains no information |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with formula
=IF(H4="","",H4+30)
-- Gary''s Student - gsnu200789 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with formula
Maybe
=IF(H4="","",H4+30) Mike "cjbarron5" wrote: I am using =H4+30 where h4 is my date cell for my quote invoice but when h4 is blank I get 1/30/00 how can I make it show blank when h4 contains no information |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with formula
Thank You very much works great
"cjbarron5" wrote: I am using =H4+30 where h4 is my date cell for my quote invoice but when h4 is blank I get 1/30/00 how can I make it show blank when h4 contains no information |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with formula
=IF(H4="","",H4+30)
-- David Biddulph "cjbarron5" wrote in message ... I am using =H4+30 where h4 is my date cell for my quote invoice but when h4 is blank I get 1/30/00 how can I make it show blank when h4 contains no information |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
