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 in Mobile Development by Kithuzzz
• 20,660 points
26 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 by narikkadan
• 37,660 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 in Mobile Development by gaurav
• 22,040 points
17 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 in Mobile Development by gaurav
• 22,040 points
31 views
0 votes
0 answers

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

I'm gonna implement a emoji picker supporting Emoji ...READ MORE

4 days ago in Mobile Development by gaurav
• 22,040 points
8 views
0 votes
0 answers

Accurate timing in iOS

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

Nov 8 in Mobile Development by gaurav
• 22,040 points
33 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 in Mobile Development by gaurav
• 22,040 points
31 views
0 votes
0 answers

Facebook log in keep redirecting in iOS

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

Nov 8 in Mobile Development by gaurav
• 22,040 points
32 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 in Others by narikkadan
• 37,660 points
30 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 in Others by narikkadan
• 37,660 points
35 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
137 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
230 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