|
Excel Expression
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 |
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 |
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 |
| All times are GMT +1. The time now is 11:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com