HELP
Posted by scott on December 12, 2001 5:57 PM
Heres what im facing
Credit benchmark: credit amount: Difference:
1000 1200 200
1000
1000 1100 100
I need to create a formula that will do the following-
1.) Calculate the difference between the "credit benchmark" and the "credit amount" ONLY, I repeat ONLY if there has been a "credit amount" entered.
In this example we see there is no "credit amount" for the middle row. In this case I do not want a value returned, or to return a "0" value.
At the bottom of the table I will have a section which is labeled "credit benchmark YTD vs. credit written YTD" I can do that part by simply summing the values in the "difference" column.
PLEASE HELP!!!
Posted by Juan Pablo G. on December 12, 2001 6:10 PM
If this is in A:C then put in C
=IF(B2,B2-A2,0)
and drag down.
Juan Pablo G.
Posted by Joseph S. Was on December 12, 2001 6:16 PM
If Column A1 is your bench and B1 is amount then C1 is Diff. labes and row 2 is your first row of data, then in C2 add:
=If(B2>0,B2-A2,"")
then copy C2 down as you need it. JSW
