Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "JE McGimpsey" wrote in message ... One way: =MAX(0.75,ROUNDDOWN(M2*F2,2)) In article , craigwojo wrote: I've got a cell with the formula =ROUNDDOWN(M2*F2,2). What I need is if the cell information is less that .75 I need it to remain .75. Thank you, Craig This solution, I have to admit, looks nicer. /Fredrik |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Simple (?) Macro Assistance- Select, Insert, Paste, Rinse, Repeat | Excel Programming | |||
Assistance Needed in Performing Count of different types- Simple SQL, not VBL | Excel Programming |