• Status: Solved
• Priority: Medium
• Security: Public
• Views: 259

# Complete Excel if formula

I have this formula  =IF(A3<0.7,A3+0.78,A3*INDEX({1.25,1.3,1.4,1.45,1.5,1.65,1.8,1.85,1.9,1.95,2},MATCH(A3,{99999,1999.99,999.99,399.99,299.99,229.99,149.99,99.99,49.99,11.99,2.5},-1)))
I need the result to be zero if A3 is zero

So if A3 = 0 then 0 else =IF(A3<0.7,A3+0.78,A3*INDEX({1.25,1.3,1.4,1.45,1.5,1.65,1.8,1.85,1.9,1.95,2},MATCH(A3,{99999,1999.99,999.99,399.99,299.99,229.99,149.99,99.99,49.99,11.99,2.5},-1)))
0
1 Solution

Commented:
=IF(A3=0,0,IF(A3<0.7,A3+0.78,A3*INDEX({1.25,1.3,1.4,1.45,1.5,1.65,1.8,1.85,1.9,1.95,2},MATCH(A3,{99999,1999.99,999.99,399.99,299.99,229.99,149.99,99.99,49.99,11.99,2.5},-1))))
0

Sr. Systems EngineerCommented:
Couldn't you do this:
IF(A3=0,0,IF(A3<0.7,A3+0.78,A3*INDEX({1.25,1.3,1.4,1.45,1.5,1.65,1.8,1.85,1.9,1.95,2},MATCH(A3,{99999,1999.99,999.99,399.99,299.99,229.99,149.99,99.99,49.99,11.99,2.5},-1))))
0

Project CoordinatorAuthor Commented:
Thanks for the quick response!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.