Can I create a formula to return a calculation based on a certain value selected from a drop-down list?
See attachment for more details. Thanks!!!
Can I create a formula to return a calculation based on a certain value selected from a drop-down list?
See attachment for more details. Thanks!!!
Hi Nancy,
Yes, But you would do better with a LOOKUP rather than IF
If you ZIP a sample, and say what you want to achieve, we can look at it.
Ed
Does the attached Word doc not illustrate it sufficiently?
Hi Nancy,
It depends on how many rates you want to apply.
For less than 7, if will do so for example
If(d11="Associate",E11*100,if(d11="paralegal",E11*50,if........)))
If there are more than 7 you need to use a look up
Ed
Each user (attorney) will input an hourly rate for each of the 4 values.
For example: Partner $250, Associate $150, Paralegal $75, Other $40. Those are constant values in the cells at the top of the page.
If Partner is selected from the drop-down and he worked 2 hours, the formula in the FEE column should return the partner rate (250) times 2, or $500.
My idea was:
IF [cell with drop-down]=partner, then cell = HOURS*250
That kind of thing.
If the user had chosen Associate, the result would have been $300 becasue the formula would have chosen the Associate rate (150) instead. Or,
IF [cell with drop-down]=associate, then cell = HOURS*150
Just substitute the numbers I put in with the cell reference instead eg $e$2
Use the dollar signs so that whwn you copy it down, it keeps referring to that cell.
Ed
=IF(C11="Partner",D11*$C7),IF(C11="Associate",D11*$D7),IF(C11="Paralegal",D11*$E7),IF(C11="Other",D11*$F7)))
But it is not working.
Do I have too many or too few parentheses at the end?
Try this
=IF(C11="Partner",D11*$C$7,IF(C11="Associate",D11* $D$7,IF(C11="Paralegal",D11*$E$7,IF(C11="Other",D1 1*$F$7))))
Ed
THANKS!
That works.
Presently, without data, the column with the formula displays FALSE for each cell.
How can I make it just appear blank?
Glad it's working, to show blank use amended formula below
=IF(C11="Partner",D11*$C$7,IF(C11="Associate",D11* $D$7,IF(C11="Paralegal",D11*$E$7,IF(C11="Other",D1 1*$F$7,""))))
Ed
Fantastic. Made my day!
Thanks for the feedback
Ed
Could i have the final version, i have to do somthing similar and i cant work it out...i could use it as a guide!
thanks
Hi main_man,
You need to start a new thread rather than trying to add onto this one.
Give us what your are trying to achieve and the problem you have.
Ed
ive worked it out now...thanks for your offer to help edmac
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks