Any help on a formula for this?

		Microsoft Office Forums > Microsoft Excel > Excel
Any help on a formula for this?

FAQ

Thread Tools

Display Modes

01-23-2019, 08:27 AM

MSG75

Windows XP Any help on a formula for this?

Office 2016

Novice

Join Date: Jan 2019

Posts: 3

Any help on a formula for this?

Hi,

Not sure if this would be an 'IF' or a 'ROUNDUP'?

If a number is between 0.00 and 49.99 – round up to the nearest 25p

If 50 to 249.99 – round up to the nearest £1
If 250 to 499.99 – round up to the nearest £5
If 500 to 999.99 – round up to the nearest £10
If 1000+ - round to the nearest £25

This will need to be one very long question rather than the 5 bands I’ve broken it down into

Tags

#excel, #formula, #help!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If or formula help	zhead	Excel	8	04-25-2018 07:09 AM
Formula Copy Row 2 Row But Next Column In Formula From Another Tab	TimG	Excel	3	04-16-2018 09:20 PM
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
Formula Help	OTPM	Excel	2	05-22-2013 06:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:45 PM.