Understanding the formula (Excel)

[Seanni]

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):

=IF(D5="";"";IF(OR(S5=0;T5="Please select";U5="");"Open";"OK"))

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

 

[Joe4]

Welcome to the Board!

OK, let's look at the formula, and just break it down piece-by-piece:

=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".

 

[Seanni]

Welcome to the Board!

OK, let's look at the formula, and just break it down piece-by-piece:

=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!

 

[Joe4]

You are welcome.