Multiple IF statements in Excel not working

Question

For my formula, I want to add numerous IF statements. The reason for this is that I need to deactivate (mark as N/A and NA) the values that are equal to the other specific values as described below:

LP372/24/60+1=($NO372-720)/24/60+1 => If any of the values don't occur at midnight, mark them as N/A.

and

LP372/24/60+1=$NO372/24/60+1 => those values that don't occur within the noon hour should be marked as NA.

The issue is that I need to divide them, thus I can't keep them under one IF statement.

I've only used one IF statement so far, and it's nested. It looks like this:

=IF(OR((LP372/24/60+1)=(($NO372-720)/24/60+1), OR((LP372/24/60+1)=($NO372/24/60+1))),"N/A",LP372/24/60+1).

The NO372 value roughly corresponds to the time of local noon. With the knowledge that one day consists of 24 hours x 60 minutes, or 1440 minutes, we may subtract the 720 to get an approximate estimate of midday for this location.

The above formula produces a pleasing result, but it omits the divide between noon and midnight that I am referring to.

Is there a way to set up multiple IF statements? I need to:

• make the values equal to midnight as N/A,
• make the values equal to midday as NA
• keep the other values as they stand

Answer 1

When you add an IF statement to a formula in excel, you have to keep in mind that IF statements have 3 parts separated with commas:

• The first value is the condition you are going to check.
• The second value is the value you want to be returned if that condition is true.
• The third value is the value you want to be returned if that condition is false.