# if statement

I need to have a formula changed in sheet  5620-Rhealth & 5640-Retire (the formulas that need tobe chaged start at g6.  they need to include the monthly figures in sheet 5390-Stipend for the 3 employees listed in this sheet.
In other words cells g6:ag29 in sheet 5620 represent the amount of dollars we have to spend in retirements cost based on an employees salary, the 3 in sheet 5390 receive an additional stipend that must also be factored into this retirement cost calculation.
expert.xlsx
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
I'm not sure I fully understood your request but take a look at the attached and let me know if it works for you.

Hope it helps!
expert.xlsx
Commented:
Hi wcody,

Information Systems SpecialistAuthor Commented:
This doesn't appear to be the solution.

Basically I want sheet 5620 & 5640 to include any salary amount from 5390 in their existing calculation.  They are simply mulitplying the salaries from sheet 5100 right now and they need to include the additional salaries listed in sheet 5390.
Information Systems SpecialistAuthor Commented:
To further clarify shet 5620 cell G8 should be sheet 5100 e8+sheet 539e6* sheet 5620f8
Commented:
I've attached a new file.  The revised formula is as follows:

=(IFERROR(VLOOKUP(\$B6,'5100-Salaries'!\$B\$6:\$AE\$29,COLUMN(G\$1)-3,FALSE),0)+IFERROR(VLOOKUP(\$B6,'5390-Stipend'!\$B\$6:\$AF\$8,COLUMN(G\$1)-3,FALSE),0))*\$F6

My formula adds the values from '5100-Salaries' to 5390-Stipend where the ID Numbers in column B match and multiples that number by the value in column F.

1) '5100-Salaries' and '5390-Stipend' together before multiple the result by column F.
2) You want all columns multipled by column F.

Let me know if that works. :)
expert.xlsx

Experts Exchange Solution brought to you by