Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Gary,
Thanks very much, that worked far simpler than I expected. I was playing around with application.worksheetfunction.round and was getting no where. Thanks again. Cheers Paul Gary Keramidas wrote: if you want to round both results, try this ROUND(IF(F20,F2*H2/100,D2*I2),0) -- Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Round Up and Round Down Time | Excel Worksheet Functions | |||
Round Off | Excel Worksheet Functions | |||
Round up or down | Excel Discussion (Misc queries) | |||
round down? | Excel Discussion (Misc queries) | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |