Forum Discussion

Alison Flynn's avatar
Alison Flynn
Copper Contributor
Jan 14, 2019
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!

 

Resources