conditional formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am formulating a project planning worksheet and would like to have a formula that when a team members initials (6 sets total) are placed in a cell that the initials will reference the correct billing rate and then multiply by the period total of hours for that member. The formula that I have been experimenting with is: IF($D3='LA',$E$163*AS3, IF($D3='JS',$E$164*AS3, IF($D3='MN',$E$165*AS3, IF($D3='DD',$E$165*AS3, IF($D3='AG',$E$166*AS3, IF($D3='DB',$E$167*AS3)))))) - where $D3 is the cell where the team members' initials are placed, and $E$165 (etc) is the cell where the billing rate is located, and AS3 is the cell where the total hours are. It seems that all of the IF and OR formulas are aimed at single True/False conditional answers. In other words, I am looking for if the initials in the cell are 'X' then the the value (billing rate) will be the appropriate value, then multiplied by the adjacent hourly totals

Thanks.
 
something like this should work. Remember to put in order. ie la could not
be before ja, etc.

=LOOKUP(D3,{"js",2;"la",1;"mn",3})*AS3
--
Don Guillett
SalesAid Software
(e-mail address removed)
Morgan Gunst said:
I am formulating a project planning worksheet and would like to have a
Click to expand...
formula that when a team members initials (6 sets total) are placed in a
cell that the initials will reference the correct billing rate and then
multiply by the period total of hours for that member. The formula that I
have been experimenting with is: IF($D3='LA',$E$163*AS3,
IF($D3='JS',$E$164*AS3, IF($D3='MN',$E$165*AS3, IF($D3='DD',$E$165*AS3,
IF($D3='AG',$E$166*AS3, IF($D3='DB',$E$167*AS3)))))) - where $D3 is the cell
where the team members' initials are placed, and $E$165 (etc) is the cell
where the billing rate is located, and AS3 is the cell where the total hours
are. It seems that all of the IF and OR formulas are aimed at single
True/False conditional answers. In other words, I am looking for if the
initials in the cell are 'X' then the the value (billing rate) will be the
appropriate value, then multiplied by the adjacent hourly totals.
 
Back
Top