MrExcel Publishing
Your One Stop for Excel Tips & Solutions

This is probably easy


Posted by Warren on May 10, 2001 10:43 PM

I want the user to place an "X" into a cell and then have the formula accept that the "X" is equal to a value in cloumn C of that row.
Then I want to be able to subtract that cell value from the grand total for that row.

I have a spreadsheet for gym member fees and i want the "X" to represent that the member has paid and to subtract that amount from the total owing by that member


Posted by Dave Hawley on May 11, 2001 1:01 AM

Hi Warren

Suppose the X goes in A1 and the number to subtract is in Cell B1 you would use:

=IF(A1="X",SUM(1:1)-B1,"")


The "1:1" is row 1
The "" means empty text

Dave

OzGrid Business Applications

Posted by Warren on May 11, 2001 7:37 AM

thanks Dave ... that was too obvious for me to see :)

Posted by Warren on May 11, 2001 8:10 AM

Dave is it possible to expand the "A1=X" to cover multiple columns