Still stuck-need a little more help please.

[TonyaH]

This formula that Frank sent me works as far as not showing an answer if my column H doesn't have an entry yet. But it doesn't show an answer when there is data in column H. I know I need to add a piece to it, but can't get it to work?

Hi, tr
=IF(H1<>"",G1-H1,""

-
Regard
Frank Kabe
Frankfurt, German

TonyaH wrote

 

[DDM]

Tonya, Frank Kabel's formula assumes there is data in G1 AND H1, and that
you want to subtract the value in H1 from the value in G1. If the data in
Column H is in some other cell, reference that cell instead. (If necessary,
post back with more details.)
--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

This formula that Frank sent me works as far as not showing an answer if

my column H doesn't have an entry yet. But it doesn't show an answer when
there is data in column H. I know I need to add a piece to it, but can't
get it to work?