Thread: [Solved] Any help on a formula for this?
View Single Post
 
Old 01-28-2019, 08:40 AM
MSG75 MSG75 is offline Windows XP Office 2016
Novice
  
Join Date: Jan 2019
Posts: 3
MSG75 is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
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))
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?
Reply With Quote