Allowing text in a cell only if another has text.

[warpathmechanic]

Here is my situation.

I have checkboxes in an excel sheet referenced to G11-G15 respectively

In E16-E20 I have the following:

=IF(AND(G11=TRUE),F11&" Premium","")

So that the text appears only if the Checkbox is checked.

In F16-F20. I am trying to force it where when E16-20 is blank or becomes blank, any text in F16-F20 is removed. If E16-20 has text, then a user can add a decimal number to the cell.

I have tried data validation, IF statements. I get close but its always with a circular reference.

Can Anyone Help?ray:

 

[Scott Huish]

it no longer allows anything other than a decimal

That's what you asked for:

If E16-20 has text, then a user can add a decimal number to the cell.