view the formula

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
 
R

Ron Rosenfeld

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with searching through content and delete unwnated column 0
Using FIND to highlight text (with dashes) 4
Solving two equations with known exponent 5
view the formula 2
Page numbering with Merged Document and IF statements 1
Two Totals from the same column 2
COUNTIF + ADDRESS Issue 1
Macro to delete row if cells greater than certain value 1

Top