Forum Discussion
Can the value of one cell be determined by the value of another?
In other words if cell C1 = "RATE" I want the value of E1 to be blank so the user can key in the numeric value of the rate manually. But if the value of C1 = 1.5 or any numeric number or changed to...
Hi GregINd
You would use if function in E1, to check the value in c1, if it is "rate", leave the cell blank otherwise return c1*d1
=IF(C1="rate","",sum(c1*d1))
Thank you! I will give the If statement a try...