Diplaying results of a formula instead of the formula itself

  • Thread starter Thread starter DirtyBadger
  • Start date Start date
D

DirtyBadger

I have a formula which is an IF statement which looks at a cell ref on a
seperate worksheet and pulls back the information contained in the cell if it
is populated but leaves it blank if it has no data present, i have placed
what i have below.

=IF(Data!D7>" ",0,Data!D7)

My question is when i hit return it still shows the formula and not the
result...the rest of the workbook seems to work as normal?

Help Please
 
Hi,

It may be text. Select the cell and re-format as general. With the cell
still selected tap F2 and then Enter.

Mike
 

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

Formula - If Statement with blank 3
IF OR AND in same conditional formula 2
IF statement when formula result is blank 2
Counting Results of Formulas 1
0.1 to 0.99 not recognised or calculated when results from formula 7
excel not recognising numbers containing 0.1calculated by formulas 4
Why does forumula show in cell instead of formula result? 2
formula displays as a formula, not as its result 1

Back
Top