IF statement question.

Zac

Well-known Member
Joined
Feb 20, 2002
Messages
796
In the following formula,

=IF(H813="OPEN","OPEN",IF(H813="","",H813-$J$3))

What does the "","" mean or cause?

Zac
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

mk000

Board Regular
Joined
Dec 10, 2004
Messages
234
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
 

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
 

Forum statistics

Threads
1,147,844
Messages
5,743,510
Members
423,800
Latest member
IuneKeiki

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top