Simple Excel if and Function formula help

[Jyotirmaya]

I want a formula that If sum of H1 & I1 less than or equal to 2 and if I1 is greater than 0 then H1*1000+I1*500 else H1*1000+I1*500

 

[admiral100]

Try this :

=IF(H1>=2,2*1000,IF(AND(H1=0,I1<=2),500*I1,IF(H1=0,500*2,IF(H1+I1<=2,(H1*1000)+(I1*500),IF(H1+I1>2,(H1*1000)+(500*(2-H1)))))))

 

[Jyotirmaya]

Try this :

=IF(H1>=2,2*1000,IF(AND(H1=0,I1<=2),500*I1,IF(H1=0,500*2,IF(H1+I1<=2,(H1*1000)+(I1*500),IF(H1+I1>2,(H1*1000)+(500*(2-H1)))))))

Thank You

 

[Trebor76]

Give a try by ctrl+shift+enter instead of just enter with same formula.

Why - it's not meant to be an array formula??

I'm glad admiral100 was able to provide a solution

Robert

 

[Vikas Kumar]

it's not meant to be an array formula??

Absolutely. Since we are not manipulating array here. But when in a first go I tried your formula with just Enter it failed to provide Output on Else part while it get worked with CSE.
And I was surprised to see this. Also when I go through again with a new worksheet I was able to find virtual result. I think it might be some cell property of Excel Or don't know what else on First time.

Anyways please to see that OP found his solution.