| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I add round to a IF statement?
I have the following formula and I want to round the same cell. Is this
possible? =IF(C8=0,C8*J8,J8) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I add round to a IF statement?
=IF(C8=0,ROUND(C8*J8,0),round(J8,0))
"Kelly Ditsworth" wrote: I have the following formula and I want to round the same cell. Is this possible? =IF(C8=0,C8*J8,J8) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I add round to a IF statement?
Well, if C8 does equal zero, then C8*J8 will also equal zero, so your
formula could be written as: =IF(C8=0,0,J8) Did you mean to write: =IF(C8=0,J8,J8*C8) ? Anyway, to round it to 2 decimal places, for example, you can just put ROUND around your formula (whichever it is) like this: =ROUND(your_formula,2) Hope this helps. Pete On Sep 2, 12:51*am, Kelly Ditsworth <Kelly wrote: I have the following formula and I want to round the same cell. *Is this possible? =IF(C8=0,C8*J8,J8) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I add round to a IF statement?
Sean: It worked like a champ. I been fighting this for quite awhile.
thanks so much! "Sean Timmons" wrote: =IF(C8=0,ROUND(C8*J8,0),round(J8,0)) "Kelly Ditsworth" wrote: I have the following formula and I want to round the same cell. Is this possible? =IF(C8=0,C8*J8,J8) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I add round to a IF statement?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Round function in If statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| Round in an IF statement | Excel Discussion (Misc queries) | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Linear Mode
