Solved

Complete Excel if formula

Posted on 2011-09-07
3
250 Views
Last Modified: 2012-05-12
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
Comment
Question by:padillrr
3 Comments
 
LVL 10

Accepted Solution

by:
SANTABABY earned 125 total points
ID: 36500165
=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
 
LVL 2

Expert Comment

by:Jesse Weeks
ID: 36500178
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
 

Author Closing Comment

by:padillrr
ID: 36500283
Thanks for the quick response!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question