Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula in a cell, keep the answer from going over a certain value
I am trying to figure out if there is a way to keep a formula in a cell from
the answer going over a certain value. say for example I want to take a value in one cell (say it was 140) and times it by 12. That equals 1680. But i dont want it to apear on the spread sheet more than 1500. but if the cell is 100 and you times it by 12 that equals 1200, and that is ok. Just dont want the end result ever going over 1500. hopefully that makes sence to some one else, and they know how to do it! Thank you!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula in a cell, keep the answer from going over a certain value
Maybe
=MIN(A1*12,1500) Mike "Eric" wrote: I am trying to figure out if there is a way to keep a formula in a cell from the answer going over a certain value. say for example I want to take a value in one cell (say it was 140) and times it by 12. That equals 1680. But i dont want it to apear on the spread sheet more than 1500. but if the cell is 100 and you times it by 12 that equals 1200, and that is ok. Just dont want the end result ever going over 1500. hopefully that makes sence to some one else, and they know how to do it! Thank you!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel cell in formula not refreshing answer cell | Excel Discussion (Misc queries) | |||
can excel show only the answer to a formula in the cell | Excel Discussion (Misc queries) | |||
count # of instances in cell (a b a) answer 2 formula if possible | Excel Worksheet Functions | |||
HOW DO I GET THE ANSWER TO A FORMULA BY PRESSING ENTER IN CELL? | Excel Discussion (Misc queries) | |||
Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) |