Forum Discussion
How to set conditional values of a cell base on the value of another cell
I'm a very basic user of excel so please forgive my ignorance. I'm attempting to assign a cell a specific value base on certain conditions of another cells value. I'm inputing score cards for my g...
Hi mdmiles1485
you are already very close with your formula.
=IF(C39=4;2;0)
It gives 2 if the value in cell C39 = 4, otherwise it gives 0