Windows XP, Officer 2003, EXCEL
Need formula to perform specific varying functions that will multiply a named CEL by a specific number that will vary by letters entered into a CEL.
Example: CELL Entry is Letter "P". Want another cell to perform and display result of A1*.6
CELL Entry is Letter "B". Want same cell above to perform and display result of A1*.4
CELL Entry is "B/P". Want same cell above to perform and display result of A1*.5
I can do the IF thing and get the formula to work for two arguments, but need to get results for the THREE arguments indicated above.
Need formula to perform specific varying functions that will multiply a named CEL by a specific number that will vary by letters entered into a CEL.
Example: CELL Entry is Letter "P". Want another cell to perform and display result of A1*.6
CELL Entry is Letter "B". Want same cell above to perform and display result of A1*.4
CELL Entry is "B/P". Want same cell above to perform and display result of A1*.5
I can do the IF thing and get the formula to work for two arguments, but need to get results for the THREE arguments indicated above.