IF statement question.

Zac

Well-known Member
In the following formula,

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

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

Zac

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

mk000

Board Regular
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
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

Replies
2
Views
398
Replies
2
Views
162
Replies
9
Views
491
Replies
3
Views
116
Replies
1
Views
234

1,181,813
Messages
5,932,198
Members
436,823
Latest member
kailose

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.

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

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