IF Statement Help

[RileyJH]

Hi all! Just wondering if you have any ideas what the IF statement could be for 'if the sub total is greater than 20'000, then its discount would be 10% of the total'.

 

[etaf]

=IF ( range to calculate the sub total > 20000 , total * 0.1 , "what to do if not , i assume just the total")

 

[RileyJH]

=IF(C7>65000,C7*0.1) - I put this in and it came up false?! Bleh

 

[etaf]

so false because C7 is less than 65000
and you do not have a false statement hence false

IF( Test, True, False)
is the format

 

[RileyJH]

so false because C7 is less than 65000
and you do not have a false statement hence false

IF( Test, True, False)
is the format

Ooh ok. Thank you. It asks me to put a total in after so the false thing just confused me. The second one gave me a figure! The third one is 'if the total is less than 30000 there is no discount' - Should I even put discount into the statement if it says this? I keep getting 0 and know Im doing it wrong.

 

[etaf]

so you are applying a discount on C7 if its over 65,000 in your example formula
your first question says 10% if greater than 20,000
and now you say if less than 30,000 there is no discount

so they do not really work out

Lets say you wanted to apply a discount and show the actual discounted price in a cell

so A1 = calculated price
and A2 = The Price with or without a discount
and a 10% discount applies for anything over 30,000

to actually calculate the new value

=IF(A1>30,000, A1*0.9, A1)

this applies a 10% discount to the value by * 90% and now shows the price you are to pay

if you just want the cell to show a % value
=IF(A1>30,000, A1*0.1, 0)

this will now show 10% of the value in the cell and if no discount applies shows 0

does that help?