-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
IF statement question.
- Thread starter Zac
- Start date
ok, simple... where the formula is...
if h813 is OPEN, it puts in this cell OPEN...
if h813 is blank, it puts a blank in this cell...
if neither the first two, it puts h813 minus j3 in this cell...
In the following formula,
=IF(H813="OPEN","OPEN",IF(H813="","",H813-$J$3))
What does the "","" mean or cause?
Zac
if h813 is OPEN, it puts in this cell OPEN...
if h813 is blank, it puts a blank in this cell...
if neither the first two, it puts h813 minus j3 in this cell...
In the following formula,
=IF(H813="OPEN","OPEN",IF(H813="","",H813-$J$3))
What does the "","" mean or cause?
Zac
Upvote
0
Barry Katcher
Well-known Member
- Joined
- Feb 25, 2002
- Messages
- 4,053
The "" is used to enclose text. For instance, IF(H813="OPEN" asks "does cell H813 contain the text OPEN". When there is nothing in between the "", that asks "does cell H813 contain nothing (no entry or blank)".
Therefore, that part of your formula (IF(H813="","") says:
If cell H813 contains nothing/no entry/blank, return nothing/no entry/blank
Barry
Therefore, that part of your formula (IF(H813="","") says:
If cell H813 contains nothing/no entry/blank, return nothing/no entry/blank
Barry
Upvote
0
