This was great! Thank you!

"Domenic" wrote:


Try the following...

=IF(B241,"None",-CEILING(B24,-5000))

OR

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

Hope this helps!

Yubasus Wrote:
Hello,

I have an expression that goes like this
=IF(B241,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
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=320487