reading another cell to place 4 amount

M

manickmj

I am trying to add a formula that will figure out a dollar amount.

example

cell a1 has the number 12 in it

I want cell b1 to say $100 if cell A1 is between 12-14, if not i
should be zero.

thank you in advance,
Mike Manic
 
R

RagDyer

If A1 will only contain whole numbers, no decimals:

=(OR(A1={12,13,14}))*100

If A1 can contain any value between 12 and 14:

=AND(A1>=12,A1<=14)*100
--

HTH,

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


I am trying to add a formula that will figure out a dollar amount.

example

cell a1 has the number 12 in it

I want cell b1 to say $100 if cell A1 is between 12-14, if not it
should be zero.

thank you in advance,
Mike Manick
 
Top