| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel | |||
| Creating GIFs in Excel 2003 for use in Dreamweaver | Charts and Charting in Excel | |||
| Charting Data from Excel | Charts and Charting in Excel | |||
| Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Hybrid Mode
