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
wcodyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
csoussanConnect With a Mentor 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.

I made the following assumptions:

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
0
 
csoussanCommented:
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
0
 
csoussanCommented:
Hi wcody,

Any update on your issue?
0
 
wcodyAuthor 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.
0
 
wcodyAuthor Commented:
To further clarify shet 5620 cell G8 should be sheet 5100 e8+sheet 539e6* sheet 5620f8
0
All Courses

From novice to tech pro — start learning today.