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
 
Back
Top