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)))
padillrrProject CoordinatorAsked:
Who is Participating?
 
SANTABABYConnect With a Mentor 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
 
Jesse WeeksSr. 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
 
padillrrProject CoordinatorAuthor Commented:
Thanks for the quick response!
0
All Courses

From novice to tech pro — start learning today.