Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formula
I have two worksheets
Worksheet 1 has the main information Column A1: M Column B1: $12.5 Column B1: S Column B2: $17.00 Worksheet 2 has a value of M or S in column B and a number in column A I want to have the formula look up the letter in Column B worksheet 2 for a match in Worksheet 1 and determine if it is an M or S and then return the value of $12.50 or $17 and then multiply it by column A in Worksheet 2. The answer will be in Workseet 2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formula | Excel Discussion (Misc queries) | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
Conditional Sum Formula | Excel Discussion (Misc queries) |