MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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