 • 445K Members
• 9,012 Online
• 536K Conversations
SOLVED

# Can't figure it out!

Hi guys,

I've been working off the following formula and it's been working perfectly.  I now need to change the parameters somewhat and I'm struggling to get it to work.

If anyone could shed some light on it , I'm be most grateful!

Here's the original one:

=IF(AND(AT2>40,H2="M"),1,IF(AND(AT2>35,H2="F"),1,IF(AP2>30,1,0)))

So if AT2 is over 40 and H2 is Male, then its 1

If AT2 is >35 and H2 is Female then is 1

Also if AP is over 30 then it's 1 otherwise it's 0

What I've to change and add in is:

If AT2 is >=40 and H2=M then it's 0, if AT2 is >=37 then it's 5 otherwise it's 10, if AT2 is >=35 and H2 is F then it's 0, if AT2 is >=31.5 then it's 5 otherwise it's 10

And if AP2 is >=30 then it's 0, if AP2 is >=25 then it's 5, otherwise it's 10.

What I've put together is this:

=IF(AND(AT34>=40,H34="M"),0,IF(AND(AT34>=37,H34="M"),5,10,IF(AND(AT34>=35,H34="F"),0,IF(AND(AT34>=31.5,H34="F"),5,10,IF(AP34>=30),0,IF(AP34>=25)5,0)))))))

but it's not working for me - not sure how to correct it, any ideas???

Thanks in advance for helping out!

2 Replies
Highlighted
Solution

# Re: Can't figure it out!

That's right Sergei, I hadn't any a response so I posted a more simpler version.

Well spotted!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
11 Replies