papichulo184
New Member
- Joined
- Feb 28, 2007
- Messages
- 32
Hi All,
How can i return a blank cell if the formula is looking at a blank cell with IF function?
E.g. IF(A1=" "," "," ")
(This is part of a bigger statement which returns a date if and when there is a date in the cell, if there isn't it comes up with an answer even though it should be blank)
Many thanks
How can i return a blank cell if the formula is looking at a blank cell with IF function?
E.g. IF(A1=" "," "," ")
(This is part of a bigger statement which returns a date if and when there is a date in the cell, if there isn't it comes up with an answer even though it should be blank)
Many thanks