IF Function
I have the following formula attached to the end of several other if functions defining the value of a cell. IF((-BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3)<0,0) But the problem is that if the result of -BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3 isn't < 0 I want it to display what -BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3 is? Can anybody help? Cheers -- chris_h_465 ------------------------------------------------------------------------ chris_h_465's Profile: http://www.excelforum.com/member.php...o&userid=28233 View this thread: http://www.excelforum.com/showthread...hreadid=490698 |
IF Function
Hi
Try this: IF(-BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3<0,0,-BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3) Andy "chris_h_465" wrote in message ... I have the following formula attached to the end of several other if functions defining the value of a cell. IF((-BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3)<0,0) But the problem is that if the result of -BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3 isn't < 0 I want it to display what -BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3 is? Can anybody help? Cheers -- chris_h_465 ------------------------------------------------------------------------ chris_h_465's Profile: http://www.excelforum.com/member.php...o&userid=28233 View this thread: http://www.excelforum.com/showthread...hreadid=490698 |
IF Function
IF((-BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3)<0,0)
Hi. Note that with something like -X-Y-Z < 0 If you multiply both sides by -1, then you have X+Y+Z0 =MIN(SUM(BY3,CA3,CC3:CJ3),0) HTH :) -- Dana DeLouis Win XP & Office 2003 "chris_h_465" wrote in message ... I have the following formula attached to the end of several other if functions defining the value of a cell. IF((-BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3)<0,0) But the problem is that if the result of -BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3 isn't < 0 I want it to display what -BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3 is? Can anybody help? Cheers -- chris_h_465 ------------------------------------------------------------------------ chris_h_465's Profile: http://www.excelforum.com/member.php...o&userid=28233 View this thread: http://www.excelforum.com/showthread...hreadid=490698 |
All times are GMT +1. The time now is 04:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com