Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks Ron & Tim
Things are working great Thanks again Chomp "tim m" wrote: =IF(A1+A2125,125,A1+A2) I wasn't sure about the wording of your example but you could see if this will do the trick. "The Chomp" wrote: Good Day; I am trying to do the following; sum cell A1 * A2 cells that total $135.98 I have a top dollar amount of $125 If the total of 2 cells is greater than () $125.00 I want the total cell to have the value $125.00 Any ideas Thanks Chomp |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |