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...
emligh Try this in F14:
=E14*10*(G14="Win")
This trick here is that you always multiply the bet by 10 and then multiply by 1 or 0. The bit G14="Win" returns either TRUE or FALSE, and these represent either 1 or 0. Anything else then Win in G14 will result in 0.
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")