help with formula

J

jladika

i am setting up a simple spreadsheet
I want to have a cell when i put a amount under $100.00 to in anothe
cell substract 10% then if I put a amout over $100.00 to subtract 20%

test l $95.00 l ? l

test l $125.00 l ?
 
J

JulieD

Hi

=IF(B2<100,B2-(B2*10%),IF(B2>100,B2-(B2*20%),B2))

you didn't say what you wanted to happen if B2 = 100, so i'm just putting B2
in the cell if it =100
alternatively if you want if B2 less than or equal to 100 then subtract 10%
the formula would be
=IF(B2<=100,B2-(B2*10%),B2-(B2*20%))

Cheers
JulieD
 
R

RagDyeR

You didn't mention what to do with 100.
How about this, where I took the liberty of adding 100 to the 10% discount
list:

=(A1<=100)*(A1*0.9)+(A1>100)*(A1*0.8)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================





i am setting up a simple spreadsheet
I want to have a cell when i put a amount under $100.00 to in another
cell substract 10% then if I put a amout over $100.00 to subtract 20%

test l $95.00 l ? l

test l $125.00 l ? l
 
J

James R-S

A couple of approaches.

=RC[-1]*(1-IF(RC[-1]>=100,0.2,0.1))
=RC[-1]*(1-CHOOSE(MATCH(RC[-1],{0,100}),0.1,0.2))

The first is the most basic, but if you're likely to increase the range of
options then the second becomes simpler.

James.
 
Top