=IF(AND(G48>10,H48>200),OR(H48>400),G48,0)

  • Thread starter Thread starter holly
  • Start date Start date
H

holly

Can anyone help?
If the number in "G" is greater than 10 AND the number in
H is greater than 200

OR if the number in H is greater than 400

Then I want it to retrun F48

Otherwise "0"

WHERE SHOULD MY PARENTHESIS BE??!

Thanks!
 
Try this

=if(h48>400,g48,if(g48>10,if(h48>200,g48,0),0),0)

It's saying "If H48 exceeds 400, use G48 regardless. If not, check G48
If G48 exceeds 10, check H48 as well; if H48 then exceeds 200, use G48
If it does not, use 0. If G48 does not exceed 10 in the first place
use 0"

I presume from the subject of your post that you are trying to retriev
G48, even though your detail states F48 ('Then I want it to retru
F48').

Either way, adapt the line above to suit your needs.

Hope that helps

Bo
 
Back
Top