view the formula

  • Thread starter Thread starter hanan
  • Start date Start date
H

hanan

All the sudden I see the formula in the bar in a different way-
relativley to other cells. For example
=IF(R[-7]C[1]<R[-7]C[7],R[-7]C[1]*0.11,R[-7]C[7]*0.11)

Please advise how I can switch it to normal view.


Hanan
 
All the sudden I see the formula in the bar in a different way-
relativley to other cells. For example
=IF(R[-7]C[1]<R[-7]C[7],R[-7]C[1]*0.11,R[-7]C[7]*0.11)

Please advise how I can switch it to normal view.


Hanan
Click to expand...


Tools/Options/General/Settings
DEselect R1C1 reference style


--ron
 
Back
Top