Excel Expression

[Guest]

Hello,

I have an expression that goes like this
=IF(B24>1,0,CEILING(B24,-5000))*(-1). This expression is giving me a zero
value if B24 is greater then 1. I would like to see if any of you could help
me and have this expression give me back "NONE" if B24 is greater then 1.

I will appreciate your help.

Yubasus

 

[Domenic]

Try the following...

=IF(B24>1,"None",-CEILING(B24,-5000))

OR

=IF(B24>1,"None",ABS(CEILING(B24,-5000)))

Hope this helps!

 

[Guest]

This was great! Thank you!

Try the following...

=IF(B24>1,"None",-CEILING(B24,-5000))

OR

=IF(B24>1,"None",ABS(CEILING(B24,-5000)))

Hope this helps!