Excell Formula Help

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

ksquared

Thread Starter
Joined
Apr 19, 2004
Messages
68
I'm new to building formulas and need some help. WHen I'm done building my formula the only thing that displays in the cell is the formula itself, not the results.


cell L2 contents: =IF(F2="",H2,F2)

what I'm attempting to do:
if F2 is has no data, copy the contents of cell H2 into cell L2
if cell F2 has data, copy the contents of cell F2 into cell L2

according to what I've read this formula should work. But when I hit <return> after the ), nothing happens. The contents of cell L2 shows my formula.

I hope I'm explaining this correctly. THanks
 
Joined
Feb 24, 2003
Messages
331
ksquared said:
I'm new to building formulas and need some help. WHen I'm done building my formula the only thing that displays in the cell is the formula itself, not the results.


cell L2 contents: =IF(F2="",H2,F2)

what I'm attempting to do:
if F2 is has no data, copy the contents of cell H2 into cell L2
if cell F2 has data, copy the contents of cell F2 into cell L2

according to what I've read this formula should work. But when I hit <return> after the ), nothing happens. The contents of cell L2 shows my formula.

I hope I'm explaining this correctly. THanks
The cell housing the formula maybe formatted as text. Click in the cell, go to Edit/Replace and replace = with =.
 
Joined
Oct 31, 2003
Messages
130
The formula works great here, however, if you use the "spacebar" to blank the cell, remember that it will return the "blank" to L2. If you select the cell and press "Delete", the formula will pick up H2. Just an FYI.
 

ksquared

Thread Starter
Joined
Apr 19, 2004
Messages
68
I did have the formula ticked (did this while trying to fix my problem). Un-ticking fixed the issue with none of my formulas working but not the formula in the spreadsheet I was working on. THe cell I was writing the formula in was formated as "text". Changed the formatting and issue resolved. THank-you both so very much. :)
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top