view the formula

[hanan]

All the sudden I view the formulas in the bar in a relativley to othe
cells
=IF(R[-7]C[1]<R[-7]C[7],R[-7]C[1]*0.11,R[-7]C[7]*0.11)

I dont know how to switch to a normal view.

Please advise.

Hana

 

[J.E. McGimpsey]

See answer posted elsewhere. Please don't post the same message in
multiple groups - it just fragments any answers you get, and wastes
the time of those who are replying to a post that's already been
answered.

 

[Ron Rosenfeld]

All the sudden I view the formulas in the bar in a relativley to other
cells
=IF(R[-7]C[1]<R[-7]C[7],R[-7]C[1]*0.11,R[-7]C[7]*0.11)

I dont know how to switch to a normal view.

Please advise.

Hanan

Please post in just one group.

Tools/Options/General/Settings
DEselect R1C1 reference style
--ron