Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

if statement

Posted on 2012-03-16
5
Medium Priority
?
176 Views
Last Modified: 2012-03-21
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
0
Comment
Question by:wcody
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 8

Expert Comment

by:csoussan
ID: 37730971
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
 
LVL 8

Expert Comment

by:csoussan
ID: 37737789
Hi wcody,

Any update on your issue?
0
 

Author Comment

by:wcody
ID: 37738680
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
 

Author Comment

by:wcody
ID: 37738821
To further clarify shet 5620 cell G8 should be sheet 5100 e8+sheet 539e6* sheet 5620f8
0
 
LVL 8

Accepted Solution

by:
csoussan earned 2000 total points
ID: 37740307
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question