Excel help

Highlighted
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
Highlighted

@Gerardjoseph2 

That could be

=C4*D4*(100*(E4="option")+(E4="stock"))+H4