| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the difference
Please help me with the following problem.
If cell A1 = 60 or less than equals 0. But if cell A1 = more than 60, say 80, than I would like to get the difference so I can multiply it by a $$ amount. Thank you for any help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding the difference
=if(a160,a1-60,0)*whatever
-- Don Guillett Microsoft MVP Excel SalesAid Software "Heather" wrote in message ... Please help me with the following problem. If cell A1 = 60 or less than equals 0. But if cell A1 = more than 60, say 80, than I would like to get the difference so I can multiply it by a $$ amount. Thank you for any help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding the difference
On Fri, 1 Aug 2008 06:42:00 -0700, Heather
wrote: Please help me with the following problem. If cell A1 = 60 or less than equals 0. But if cell A1 = more than 60, say 80, than I would like to get the difference so I can multiply it by a $$ amount. Thank you for any help! Try this formula: =IF(A1<60,0,A1-60) Hope this helps / Lars-Åke |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding the difference
You can do it this way:
=MAX(A1-60,0) Hope this helps. Pete On Aug 1, 2:42*pm, Heather wrote: Please help me with the following problem. If cell A1 = 60 or less than equals 0. But if cell A1 = more than 60, say 80, *than I would like to get the difference so I can multiply it by a $$ amount. Thank you for any help! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding the difference
Heather
Maybe =IF(A1<=60,"",A1-60) Mike "Heather" wrote: Please help me with the following problem. If cell A1 = 60 or less than equals 0. But if cell A1 = more than 60, say 80, than I would like to get the difference so I can multiply it by a $$ amount. Thank you for any help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
| Finding the difference between two numbers | Excel Worksheet Functions | |||
| Finding the percentage difference of two or more numbers | Excel Worksheet Functions | |||
| charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
| Finding Time difference | Excel Worksheet Functions | |||
Linear Mode
