Unable to get a IF Function to work, Please Help

M

Matt

I need to take a total that is being pulled from another sheet to the sheet I
am trying to get the if function to work. I am not sure if the IF function
is what I really need to use. The following is an example of what I am
trying to do:

first work sheet shows the total 10.5 however, the factor for the totals
that I need in the second work sheet has to be always at 8 ( how can I set
the that second cell to pull from the 1st cell and make it to always total
8???
 
J

JE McGimpsey

If I understand you correctly (and I'm not at all sure I do):

put this in sheet2:

=8 - Sheet1!A1

so that if Sheet1!A1 = 10.5, the formula above returns -2.5 and the
total of Sheet1!A1 and that result = 8.
 
Top