Inserting as Formula into a cell from the Formula Bar 1

[Lil8]

I am trying to use a formula in the formula into a cell

=IF(E9=0.33,"=H9",IF(E9=0.25,"=H9","=H9/G9&quot)

but it will not paste the expression as a formula but as a text string - how can formulas be pasted ? I have tried using double quotes ( as used if you are inserting as formula into a cel from a user form but to no avail.

Yours hopefully
Nick

 

[xlbo]

you don't need the '='
=IF(E9=0.33,H9,IF(E9=0.25,H9,H9/G9))

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244