| 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 |
| 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 | |||
Threaded Mode
