Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to assign a formula to a letter?
At least I think that's what I need to do.
Our contractors' commission on parts is 40% if they purchased the part themselves, and 30% if the office provided the part. The way it's set up now is the tech types "y" if they purchased the part, and "n" if it came from the office. So then we calculate their commission. So what I think I need is to have a hidden formula I can refer to in the cell that contains the $ amount of the part (hidden formula would be .40 for y, .30 for n). Is this possible? Or can you recommend another way to handle this? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to assign a formula to a letter?
Try,
=IF(A1="y",A2*0.4,IF(A1="n",A2*0.3,A2)) Mike "Judy" wrote: At least I think that's what I need to do. Our contractors' commission on parts is 40% if they purchased the part themselves, and 30% if the office provided the part. The way it's set up now is the tech types "y" if they purchased the part, and "n" if it came from the office. So then we calculate their commission. So what I think I need is to have a hidden formula I can refer to in the cell that contains the $ amount of the part (hidden formula would be .40 for y, .30 for n). Is this possible? Or can you recommend another way to handle this? Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to assign a formula to a letter?
Thank you. That works!!! I danced around the office!
"Mike H" wrote: Try, =IF(A1="y",A2*0.4,IF(A1="n",A2*0.3,A2)) Mike "Judy" wrote: At least I think that's what I need to do. Our contractors' commission on parts is 40% if they purchased the part themselves, and 30% if the office provided the part. The way it's set up now is the tech types "y" if they purchased the part, and "n" if it came from the office. So then we calculate their commission. So what I think I need is to have a hidden formula I can refer to in the cell that contains the $ amount of the part (hidden formula would be .40 for y, .30 for n). Is this possible? Or can you recommend another way to handle this? Thanks! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to assign a formula to a letter?
Hi
Another possible solution (there is no need to mark entries where office did purchasing at all): =A2*(0.3+(A1="y")) Arvi Laanemets "Mike H" wrote in message ... Try, =IF(A1="y",A2*0.4,IF(A1="n",A2*0.3,A2)) Mike "Judy" wrote: At least I think that's what I need to do. Our contractors' commission on parts is 40% if they purchased the part themselves, and 30% if the office provided the part. The way it's set up now is the tech types "y" if they purchased the part, and "n" if it came from the office. So then we calculate their commission. So what I think I need is to have a hidden formula I can refer to in the cell that contains the $ amount of the part (hidden formula would be .40 for y, .30 for n). Is this possible? Or can you recommend another way to handle this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to assign a value to the letter R in a cell range | Excel Worksheet Functions | |||
How do I assign a letter value to a range of data? | Excel Discussion (Misc queries) | |||
Can I assign a shortcut key (alt letter) to the format painter | Excel Discussion (Misc queries) | |||
How do I assign numerical values to a letter? Ex: A = 4, B=3, etc | Excel Worksheet Functions | |||
How do I assign a numeric value to a text letter | Excel Discussion (Misc queries) |