Excel help

Occasional Visitor
Hi, I have what is likely a simple issue that i cant solve. I am trying to do a formula (C4*D4*E4)+H4. However in my spreadsheet E4 is text (either ‘option’ or ‘stock’). C4, D4, and H4 are numbers. I need ‘option’ to represent 100 in my formula, and I need ‘stock’ to represent 1 in my formula. How do I do this? Please help.
1 Reply


That could be