I think you want
=IF(ISNUMBER(F4),F4+G5,"")
--
HTH
Bob Phillips
"Noob_power1242" wrote in message
...
I want to make a if then statment like (in VB format) If F4.text= true
then
caculate sum of F4,G5. If F4.text= False then G7.text= "" (blank)
I was messing around trying to make a checkbook program and when I would
apply the equastion to the G column it would display the last number
calulated in the cell above it down the entire column. I would like to
make
it to where it will only calulate the equation only if there is text in
the
proper cells.