Please help! I need multiple formulas for one cell!
 

Hello,

I was wondering if anyone can assist me with a formula. This is what I
need:

C19 is where you enter the inches
C20 adds the charge

The formula to go into C20 needs to be this:

If the number in C19 is 01" through 12" is entered, add $75. If 13"
thorugh 24" is entered, add $175, if 25" through 36" is entered, then
add $275, otherwise (or anything else), enter $0 to C20. :confused:

Btw...((" )inches quote sign does not need to be in this formula)

I would really appreciate your help.

Bella:)


--
mbdbiz
------------------------------------------------------------------------
mbdbiz's Profile: http://www.excelforum.com/member.php...o&userid=37309
View this thread: http://www.excelforum.com/showthread...hreadid=570179

Please help! I need multiple formulas for one cell!
 

=LOOKUP(C19,{0,1,13,25,37},{0,75,175,275,0})

Vaya con Dios,
Chuck, CABGx3


"mbdbiz" wrote in
message ...

Hello,

I was wondering if anyone can assist me with a formula. This is what I
need:

C19 is where you enter the inches
C20 adds the charge

The formula to go into C20 needs to be this:

If the number in C19 is 01" through 12" is entered, add $75. If 13"
thorugh 24" is entered, add $175, if 25" through 36" is entered, then
add $275, otherwise (or anything else), enter $0 to C20. :confused:

Btw...((" )inches quote sign does not need to be in this formula)

I would really appreciate your help.

Bella:)


--
mbdbiz
------------------------------------------------------------------------
mbdbiz's Profile:
http://www.excelforum.com/member.php...o&userid=37309
View this thread: http://www.excelforum.com/showthread...hreadid=570179

Please help! I need multiple formulas for one cell!
 

=IF(C19<=0,"Number is cero or smaller",IF(C19<=12,
C19+75,IF(C19<=24,C19+175,IF(C19<=36,C19+275,IF(C1 9=37,0)))))

Try the formula above, i think this is what you are looking for...
if not let me know...
If by accident you enter a cero or negative number the cell will display "Number is cero or smaller".
If the number is grated than "36" a "0" will be in your cell.


"mbdbiz" wrote:


Hello,

I was wondering if anyone can assist me with a formula. This is what I
need:

C19 is where you enter the inches
C20 adds the charge

The formula to go into C20 needs to be this:

If the number in C19 is 01" through 12" is entered, add $75. If 13"
thorugh 24" is entered, add $175, if 25" through 36" is entered, then
add $275, otherwise (or anything else), enter $0 to C20. :confused:

Btw...((" )inches quote sign does not need to be in this formula)

I would really appreciate your help.

Bella:)


--
mbdbiz
------------------------------------------------------------------------
mbdbiz's Profile: http://www.excelforum.com/member.php...o&userid=37309
View this thread: http://www.excelforum.com/showthread...hreadid=570179