I've been looking everywhere for a solution to this but I haven't found one yet.
If cell contains a specific word, then multiply two cells. But if cell contains a different word then multiply two other cells. But if the cell is blank, leave blank.
For example if Cell N4 = "Even" then multiply Cell M4 by Cell A1 and enter in Cell A4,. Or if Cell N4 = "Ramp" then multiply Cell M4 by Cell A2 and enter in Cell A4. But if Cell N4 is blank, leave Cell A4 blank.
Then I will drag the formula so it applies to all cells from A4 to cell L4.
I have attached the excel spreadsheet.
Bookmarks