if function display

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I type a formula in the "true" value, the formula is displayed and not
the result of the formula. Please advise how to ensure that the numerical
result is displayed
 
Hi

would have helped to see your formula .. but it should be in the format of:

=IF(A1=100,A1+B1,A1-B1)

if this doesn't help, please repost with your actual formula

Cheers
JulieD
 
You must log in or register to reply here.

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

Cell reference in formula string displays abbreviated value 2
Counting Results of Formulas 1
Printing formulas in worksheet 3
Lookup against concatenated source value 2
Excel VBA 1
FORMULA VS VALUE 4
formula displays as a formula, not as its result 1
Excel formula / IF function 5

Back
Top