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...
It would require VBA code, but perhaps it would be easier to use two cells:
E1 would contain the formula =C1*D1 (it isn't necessary to use SUM here).
F1 would be available for the user to fill in.
In formulas that currently refer to E1, you could use IF(C1="RATE",E1,F1) instead of E1