Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
Can you please help me with figuring out what formula I need for below. 0-85,000 units = $0 85,001 -100,000 units = $2 100,000-150,000 units = $3 if i had 90,000 units in a cell, then my result would be 90000-85000 =5,000 x $2 if i had 105,000 units in a cell,then my result should be 100,000 -85,000 =15,000 x $2 if i had 70,000 units in a cell, then my result should be 0. I need all 3 if statements in my formula in one cell. Is that possible? I think once i get this then i can go onto the next tier of the $3 in the next cell, i hope?! Thanks in advance, Karen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple if formula | Excel Discussion (Misc queries) | |||
formula to add multiple lines with multiple meanings | Excel Discussion (Misc queries) | |||
Formula to sum multiple columns on multiple criteria | Excel Discussion (Misc queries) | |||
multiple formula | Excel Discussion (Misc queries) | |||
Multiple IF formula | Excel Discussion (Misc queries) |