Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
How can I write an IF statement for the following:
If the value in cell b4 < 10, round that figure to 1 decimal place. If the value in cell b4 = 10, round that figure to 0 decimal place. Thanks, -- Sue |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
Try this:
=IF(B4<10,ROUND(B4,1),ROUND(B4,0)) HTH, Elkar "Sue" wrote: How can I write an IF statement for the following: If the value in cell b4 < 10, round that figure to 1 decimal place. If the value in cell b4 = 10, round that figure to 0 decimal place. Thanks, -- Sue |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
=IF(B4<10,ROUND(B4,1),IF(B4=10,ROUND(B4,0),""))
Vaya con Dios, Chuck, CABGx3 "Sue" wrote: How can I write an IF statement for the following: If the value in cell b4 < 10, round that figure to 1 decimal place. If the value in cell b4 = 10, round that figure to 0 decimal place. Thanks, -- Sue |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
Use:
=IF(B4<10,ROUND(B4,1),ROUND(B4,0)) -- Gary's Student "Sue" wrote: How can I write an IF statement for the following: If the value in cell b4 < 10, round that figure to 1 decimal place. If the value in cell b4 = 10, round that figure to 0 decimal place. Thanks, -- Sue |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions |