If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unable to get a IF Function to work, Please Help
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??? -- Thanks, Matt |
#2
|
|||
|
|||
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. In article , "Matt" wrote: 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??? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Named constant does not work in HYPERLINK function | BigWoof | Worksheet Functions | 1 | August 14th, 2004 07:27 AM |
Why won't the Nz function work? | ABaggott | Using Forms | 2 | May 26th, 2004 12:30 AM |
Datedif function doesn't work when I use the cell with a date as start date reference | Gord Dibben | Worksheet Functions | 0 | April 3rd, 2004 12:47 AM |
Scrolling function does not work | Crockett | Setting up and Configuration | 4 | December 12th, 2003 02:33 AM |