| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with whichever is greater formula
I have a worksheet in MS2003 and need to have a cell preform the following
function: Multiply cell U3 by .05 or display 1 whichever is greater. Any help is greatly appreciated, thanks in advance! ~Roxy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with whichever is greater formula
On Jun 21, 12:11*am, Roxy wrote:
I have a worksheet in MS2003 and *need to have a cell preform the following function: Multiply cell U3 by .05 or display 1 whichever is greater. Any help is greatly appreciated, thanks in advance! ~Roxy =IF(U3*0.5<1,U3*0.5,1) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with whichever is greater formula
Thank you Thank you Thank you!!! You are the best that worked perfectly!
Cheers! ~Roxy |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with whichever is greater formula
Multiply cell U3 by .05 or display 1 whichever is greater.
Another option is to take the "maximum" of the two values. =MAX(U3*0.05, 1) -- HTH :) Dana DeLouis "Roxy" wrote in message ... I have a worksheet in MS2003 and need to have a cell preform the following function: Multiply cell U3 by .05 or display 1 whichever is greater. Any help is greatly appreciated, thanks in advance! ~Roxy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Greater than or less than formula | Excel Discussion (Misc queries) | |||
| How: List in col D whichever number greater; B4 or varying # in Co | Excel Discussion (Misc queries) | |||
| display actual number or zero, whichever is greater | Excel Discussion (Misc queries) | |||
| whichever is greater | Excel Discussion (Misc queries) | |||
| formula SUMIF or whichever one will work for my issue | Excel Worksheet Functions | |||
Linear Mode
