Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If and Round Functions
Can someone tell me how to use the if and round functions together. My if functions is =IF($A5<1,K5-(K5*$A5),K5-$A5) and I need my answers to be round to the nearest hundred. -- billykiller05 ------------------------------------------------------------------------ billykiller05's Profile: http://www.excelforum.com/member.php...o&userid=36813 View this thread: http://www.excelforum.com/showthread...hreadid=565206 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If and Round Functions
One way:
=ROUND(K5-IF($A5<1,K5*$A5,$A5),-2) In article , billykiller05 wrote: Can someone tell me how to use the if and round functions together. My if functions is =IF($A5<1,K5-(K5*$A5),K5-$A5) and I need my answers to be round to the nearest hundred. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If and Round Functions
Try this:
=IF($A5<1,ROUND(K5-(K5*$A5),2),ROUND(K5-$A5,2)) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "billykiller05" wrote in message news:billykiller05.2bk78s_1153928416.0754@excelfor um-nospam.com... Can someone tell me how to use the if and round functions together. My if functions is =IF($A5<1,K5-(K5*$A5),K5-$A5) and I need my answers to be round to the nearest hundred. -- billykiller05 ------------------------------------------------------------------------ billykiller05's Profile: http://www.excelforum.com/member.php...o&userid=36813 View this thread: http://www.excelforum.com/showthread...hreadid=565206 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round time maybe this explanation will help | Excel Discussion (Misc queries) | |||
ROUND or "Precision as displayed"? | Excel Worksheet Functions | |||
Round a number in nested function | Excel Worksheet Functions | |||
Round whole numbers up and down | Excel Discussion (Misc queries) | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |