Multiple IF statements in Excel not working

0 votes

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.

enter image description here

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 in Mobile Development by Kithuzzz
• 38,000 points
537 views

1 answer to this question.

0 votes

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.
answered Nov 12, 2022 by narikkadan
• 63,600 points

Related Questions In Mobile Development

0 votes
0 answers

Twilio incoming call is not working in iOS

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

Nov 17, 2022 in Mobile Development by gaurav
• 23,260 points
706 views
0 votes
0 answers

FB Login not working with React Native iOS v13+

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

Nov 10, 2022 in Mobile Development by gaurav
• 23,260 points
1,237 views
0 votes
1 answer

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

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

answered Dec 12, 2022 in Mobile Development by gaurav
• 23,260 points
549 views
0 votes
0 answers

Accurate timing in iOS

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

Nov 8, 2022 in Mobile Development by gaurav
• 23,260 points
401 views
0 votes
0 answers

Swift - Find antilog for 4 digit Integer in iOS

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

Nov 8, 2022 in Mobile Development by gaurav
• 23,260 points
1,094 views
0 votes
0 answers

Facebook log in keep redirecting in iOS

I have an Unity application using Facebook ...READ MORE

Nov 8, 2022 in Mobile Development by gaurav
• 23,260 points
415 views
0 votes
1 answer

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

answered Nov 4, 2022 in Others by narikkadan
• 63,600 points
1,582 views
0 votes
1 answer

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

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

answered Nov 7, 2022 in Others by narikkadan
• 63,600 points
1,454 views
0 votes
1 answer

IfError with else, does this function exist in Excel?

Next to IFERROR(), there also is the ISERROR() function, which ...READ MORE

answered Dec 23, 2022 in Others by narikkadan
• 63,600 points
875 views
0 votes
1 answer

IF statement for a tax sheet does not work

Use vlookup() as that is much easier ...READ MORE

answered Mar 20, 2023 in Others by narikkadan
• 63,600 points
533 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP