Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This is a Mircosoft Office 2007 Excel spread sheet.
I need to figure out a formula that can round up or down to $xx.95 using the following situation cost: 18.23 mark up: 1.8 Retail-based on this alone would be $32.81 A1= Cost A3= Retail A2= Mark up Formula used in A3 is- =A1*A2 My problem is that the owner wants all cents to be rounded up or down to .95 and costs are all different throught the cost columns. Is there a formula that can be entered to do such a funtion? Thanks for any assistance you can offer. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
rounding | Excel Discussion (Misc queries) | |||
ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Rounding | Excel Discussion (Misc queries) | |||
Rounding | Excel Worksheet Functions |