Forum Discussion
Referencing text in a cell to multiple another cell
Hello all, I am fairly new to formulas in excel and was wondering if there is a formula that I can put in F14 that will reference the text in G14, "Lost", and then take the value of E14 and multipl...
Riny_van_Eekelen That worked! Thank you very much! 🙂
Do you also know a way to make the “Bet” override the manual input of 5 to 0 when the “Status” reads Not Played?
emligh Thus the the bet is always 5 unless the status is "Not Played"?
If so, you can use a similar approach.
=5*(G14<>"Not Played")