How to use ceiling with if function [SOLVED]

[smisar]

i want to use ceiling function as per the number in the cell value.

if cell value is below 10, ceiling, 0.10

if cell value is above 10, below 50, ceiling, 0.50

if cell value is below 50, ceiling, 1.0


is it possible?

 

[SirJB7]

Hi, smisar!


Try this:

=MULTIPLO.SUPERIOR(A1;SI(A1<10;0,1;SI(A1<50;0,5;1))) -----> in english: =CEILING(A1,IF(A1<10,0.1,IF(A1<50,0.5,1)))


If you have more values you'd place them in let me say worksheet Sheet2 in columns A:B and use this formula:

=CEILING(A1,VLOOKUP(A1,Sheet2!A:B,2,True)


Regards!

 

[smisar]

Dear SirJB7,


Thank you very much for your help....

Keep sharing your knowledge to the needy like us...

regards

Sanjay

 

[SirJB7]

Hi, smisar!

Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted. And remember that all of us are sometimes needy, check this that I quoted today but it's older:

http://chandoo.org/forums/topic/chandooorg-ninjas#post-116375

Regards!