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
|