Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, but, and still but, all in one formula?
I've also been playing with this, trying to use either IF, or SUMIF, or SUMPRODUCT, trying to make this work (adding B+C, compare with D, and determine if the sum is =, <, or , than D, and giving the result in E): If B9+C9=D9, then 0 but if B9+C9D9, then B9+C9-D9 (to show that "D" is x-amount less than B+C) but if B9+C9<D9, then D9-B9+C9 (to show that "D" is x-amount more than B+C) Am I making sense? LOL - I'm sure I'm close, but I keep getting the "too many arguments" error :) THANK YOU -- navychef ------------------------------------------------------------------------ navychef's Profile: http://www.excelforum.com/member.php...o&userid=29457 View this thread: http://www.excelforum.com/showthread...hreadid=493602 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, but, and still but, all in one formula?
=if((b9+c9)=d9,0,if((b9+c9)d9,b9+c9-d9,d9-b9+c9)) -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=493602 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, but, and still but, all in one formula?
Awesome, I knew I came to the right place. THANKS MUCH! -- navychef ------------------------------------------------------------------------ navychef's Profile: http://www.excelforum.com/member.php...o&userid=29457 View this thread: http://www.excelforum.com/showthread...hreadid=493602 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|