Hey guys,
Thanks for the fantastic help last time. Hoping you can help me again!
I want a formula that calculates a value by a certain amount, depending on what text is in the column next to it.
Please find sample spreadsheet attached.
So the values in column B in the DATA sheet, I want them multiplied by certain amounts, depending on what the text in column A is, and then fed over to the COSTING sheet.
Low - 1
Medium - 3
High - 6
Extreme - 10
I hope that makes sense! Let me know if you need any further information.
Cheers guys!
Bookmarks