Jyotirmaya
Board Regular
- Joined
- Dec 2, 2015
- Messages
- 205
- Office Version
- 2019
- Platform
- Windows
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
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Simple Excel if and Function formula help
- Thread starter Jyotirmaya
- Start date
admiral100
Well-known Member
- Joined
- Jan 17, 2015
- Messages
- 873
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)))))))
=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)))))))
Upvote
0
Excel Facts
Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Jyotirmaya
Board Regular
- Joined
- Dec 2, 2015
- Messages
- 205
- Office Version
- 2019
- Platform
- Windows
Thank You
Upvote
0
Vikas Kumar
New Member
- Joined
- Apr 2, 2017
- Messages
- 49
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.
Upvote
0
Similar threads
- Question
