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
Nov 12, 2022 187 views

## 1 answer to this question.

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.
• 63,180 points

## Twilio incoming call is not working in iOS

I am working on Twilio programmable voice ...READ MORE

## FB Login not working with React Native iOS v13+

I've a project with following configuration. "react": "16.8.3", "react-native": ...READ MORE

## Is there a lightweight method to check if emoji is supported in iOS?

You can easily override theme by wrapping ...READ MORE

## Accurate timing in iOS

I am looking at the 'Metronome' sample ...READ MORE

## Swift - Find antilog for 4 digit Integer in iOS

I need to find an antilog for 5995. ...READ MORE

## Excel Formula - if values in columns all contain X then return

You can use the AND function: = IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE

## (Excel) If cell is greater than <condition> then minus <number>

The IF function to calculate B5 (amount ...READ MORE