# Understanding the formula (Excel)

#### Seanni

##### New Member
Hi everyone,

I am working on a sheet in Excel. However, there is one formula implemented in the sheet which I don't understand. It is shown beneath and in the screenshot (see screenshot below, starting from column A5 downwards):

Could anybody explain to me how it works? And preferably, not in a too complicated way.

Also, when looking at the Conditional Formatting Rules, it is shown that the cell either stays uncoloured or turns green or red when filling in the other columns (see screenshot below).

I do understand that when the columns next to it are filled in correctly, either cell A will turn red (which is bad) or green (which is good).

Hope to hear from you soon,

Sean

### Excel Facts

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Welcome to the Board!

OK, let's look at the formula, and just break it down piece-by-piece:
Excel Formula:
``=IF(D5="";"";IF(OR(S5=0;T5="Please select";U5="");"Open";"OK"))``
It is first looking at cell D5, and if cell D5 is empty (nothing), it will return an empty string.
- OTHERWISE (if D5 is NOT empty), it will go on and evaluate the next IF, which says:
If S5=0 OR T5="Please select" OR U5 is empty, then return "Open".
If none of those condtions are met, it will return "OK".

Welcome to the Board!

OK, let's look at the formula, and just break it down piece-by-piece:
Excel Formula:
``=IF(D5="";"";IF(OR(S5=0;T5="Please select";U5="");"Open";"OK"))``
It is first looking at cell D5, and if cell D5 is empty (nothing), it will return an empty string.
- OTHERWISE (if D5 is NOT empty), it will go on and evaluate the next IF, which says:
If S5=0 OR T5="Please select" OR U5 is empty, then return "Open".
If none of those condtions are met, it will return "OK".
Yes, I understand it now! Thank you!

You are welcome.

Replies
5
Views
160
Replies
5
Views
247
Replies
4
Views
314
Replies
3
Views
365
Replies
8
Views
481

1,203,631
Messages
6,056,432
Members
444,864
Latest member
Thundama

### 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.

### Which adblocker are you using?

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