Ray Padilla
asked on
Complete Excel if formula
I have this formula =IF(A3<0.7,A3+0.78,A3*INDE X({1.25,1. 3,1.4,1.45 ,1.5,1.65, 1.8,1.85,1 .9,1.95,2} ,MATCH(A3, {99999,199 9.99,999.9 9,399.99,2 99.99,229. 99,149.99, 99.99,49.9 9,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*INDE X({1.25,1. 3,1.4,1.45 ,1.5,1.65, 1.8,1.85,1 .9,1.95,2} ,MATCH(A3, {99999,199 9.99,999.9 9,399.99,2 99.99,229. 99,149.99, 99.99,49.9 9,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*INDE
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the quick response!
IF(A3=0,0,IF(A3<0.7,A3+0.7