Any help on a formula for this?

xor · #1 01-24-2019, 03:53 AM

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))

MSG75 · #2 01-28-2019, 08:40 AM

Quote:

Originally Posted by xor

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?

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