| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I tell a price list to round up and down to the nearest 25
Try...
=ROUND(25.68/0.25,0)*0.25 Hope this helps! In article , "Philippa" wrote: I have created a price list in excel but the amounts are coming out at say £25.68 and I would like to tell it to round up or down to the nearest 25p can I do this |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
