Microsoft Office Forums - View Single Post - [Solved] Any help on a formula for this?

Thread: [Solved] Any help on a formula for this?

View Single Post

Old

01-28-2019, 09:50 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

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

Reply With Quote