#1




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 
#2




Hi and welcome
This seems to work =CEILING(I9,FLOOR(I9/50,1)+(0.25*(I9<50))+5*(I9>=1000)) (replace I9 with your cell ref) In the future please add a small sample sheet ( no pics please) with desired results and some data
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be) Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank. 
#3




Thanks for the reply @Pecoflyer
I've tried using this formula, however it doesn't appear to be working as I expected. Some of the sums do, but then the larger numbers are skewed. Any ideas? I was wondering if this would be an 'IF' rather than 'CEILING'? Trying to add an example but don't know how? 
#4




You might want to try this one
=IFS(A1<50,CEILING(A1,0.25),A1<250,CEILING(A1,1),A 1<450,CEILING(A1,5),A1<1000,CEILING(A1,10),A1>=100 0,CEILING(A1,25)) 
#5




Another possible solution!

#6




Here is same formula using only one (and fixed, not dynamic) named range  it is easier to edit this one.

#7




Sorry one more question! A colleague has a different version of Excel (2016) and IFS is not available and returns an error  any way round this?

#8




=if(a1<50,ceiling(a1,0.25),if(a1<250,ceiling(a1,1) ,if(a1<450,ceiling(a1,5),if(a1<1000,ceiling(a1,10) ,if(a1>=1000,ceiling(a1,25))))))

Tags 
#excel, #formula, #help! 
Thread Tools  
Display Modes  

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