I Need A IF Statement

Microsoft Microsoft office excel 2007 ac...
April 16, 2010 at 18:36:19
Specs: Windows Vista
Hi I really need help on my IF statement.

If a customer spends over $150.00 at our store he is eligible for a 5% discount and if he is not eligible show me the total costs which is in the cell previous to final costs.

Thanks for any help I could get and any formula in the simplest form is most best, however IF statements are awfully long.

HI I REALLY NEED HELP ON MY IF STATEMENT.

IF A CUSTOMER SPENDS OVER $150.00 AT OUR STORE HE IS ELIGIBLE FOR A 5% DISCOUNT AND IF HE IS NOT ELIGIBLE SHOW ME THE TOTAL COSTS WHICH IS IN THE CELL PREVIOUS TO FINAL COSTS.

THANKS FOR ANY HELP I COULD GET AND ANY FORMULA IN THE SIMPLEST FORM IS MOST BEST, HOWEVER IF STATEMENTS ARE AWFULLY LONG

edited by moderator: Changed text to lower case


See More: I Need A IF Statement

Report •


#1
April 16, 2010 at 19:57:37
Please refrain from posting in all caps.

All caps is the Internet equivalent of shouting and no one likes to be yelled at.

It might help if you provided an example of your data, with inputs and outputs, but I'll give it a shot:

Let's say you have a list of numbers in A1:A5:

In A6 you have =SUM(A1:A5)

In A7 use:

=IF(A6>150, A6 - A6*0.05, A6)

If A6 is greater than 150, return A6 minus 5% of A6. If not, return A6.

I hope that helps.


Report •
Related Solutions


Ask Question