|
2 if functions together
How can I use 2 if functions together. My function is =IF($U9<1,ROUND(AK9-(AK9*$U9),-2),ROUND(AK9-$U9,-2)) and if U9 is greater than 1 and some of my cells in the range are 0 it gives me a negative number. How can I add another if function to change the negative numbers to zero? -- billykiller05 ------------------------------------------------------------------------ billykiller05's Profile: http://www.excelforum.com/member.php...o&userid=36813 View this thread: http://www.excelforum.com/showthread...hreadid=565246 |
2 if functions together
One possible way
=MAX(IF($U9<1,ROUND(AK9-(AK9*$U9),-2),ROUND(AK9-$U9,-2)),0) meaning that if the IF function returns less than zero the result will be zero -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "billykiller05" wrote in message news:billykiller05.2bkbes_1153933813.0031@excelfor um-nospam.com... How can I use 2 if functions together. My function is =IF($U9<1,ROUND(AK9-(AK9*$U9),-2),ROUND(AK9-$U9,-2)) and if U9 is greater than 1 and some of my cells in the range are 0 it gives me a negative number. How can I add another if function to change the negative numbers to zero? -- billykiller05 ------------------------------------------------------------------------ billykiller05's Profile: http://www.excelforum.com/member.php...o&userid=36813 View this thread: http://www.excelforum.com/showthread...hreadid=565246 |
| All times are GMT +1. The time now is 10:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com