| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum Value in a Cell
I need to multiply cell G2 by $25. The maximum value should be $250. Can
anyone help me write this? I've checked some of the other formulas, and can't seem to make it work for my situation. Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maximum Value in a Cell
Try
=MIN(G2*25,250) Regards, Peo Sjoblom "Teri" wrote in message ... I need to multiply cell G2 by $25. The maximum value should be $250. Can anyone help me write this? I've checked some of the other formulas, and can't seem to make it work for my situation. Thank you! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maximum Value in a Cell
=MIN(250,G2*25)
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Teri" wrote in message ... I need to multiply cell G2 by $25. The maximum value should be $250. Can anyone help me write this? I've checked some of the other formulas, and can't seem to make it work for my situation. Thank you! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maximum Value in a Cell
That was so simple!!! Thank you both of you! I don't know why I couldn't
make it work.. "Bernard Liengme" wrote: =MIN(250,G2*25) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Teri" wrote in message ... I need to multiply cell G2 by $25. The maximum value should be $250. Can anyone help me write this? I've checked some of the other formulas, and can't seem to make it work for my situation. Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maximum value in a cell | Excel Discussion (Misc queries) | |||
| Auto sum with maximum value in a cell. Please help! | Excel Worksheet Functions | |||
| Maximum and minimum cell value | Excel Discussion (Misc queries) | |||
| format cell with maximum value | Excel Discussion (Misc queries) | |||
| MAXIMUM NUMBERS IN CELL | New Users to Excel | |||
Linear Mode
