Can the value of one cell be determined by the value of another?

[GregINd]

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 a number from the value of "RATE", then the value of E1 should be a formula which is =sum(C1*D1).  Is this possible??  

Users need the ability to change their minds in regard to the value of C1.  They need to change from the value of "RATE" back to a numeric number when necessary.  My issue is under this circumstance, there is no longer any formula in E1 because it was overwritten with a flat rate value.  I hope this makes sense.  I have not figured any solution for this

Greg I

[#2]

@GregINd 

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

[#3]

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))

[#4]

Thank you! I will give the If statement a try...