Still stuck-need a little more help please.

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

Guest

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


TonyaH said:
This formula that Frank sent me works as far as not showing an answer if
Click to expand...
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?
 
Back
Top