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

[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!

 

[Frank Kabel]

Hi Holly
try
=IF(or(AND(G1>10;H1>200),H1>400),F1,0)

HTH
Frank

 

[elanus]

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

 

[M@x]

Hi,

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

M@

 

[Roger Govier]

Hi Holly

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

 

[Guest]

Thanks! That worked perfectly!!!
Appreciate it greatly!