Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple, need assistance
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 t remain .75. Thank you, Crai -- craigwoj ----------------------------------------------------------------------- craigwojo's Profile: http://www.excelforum.com/member.php...fo&userid=1376 View this thread: http://www.excelforum.com/showthread.php?threadid=33266 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple, need assistance
"craigwojo" wrote in message ... 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 Like this? =IF(M2*F2,2<.75,.75,ROUNDDOWN(M2*F2,2)) /Fredrik |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple, need assistance
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple, need assistance
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |