If function
 

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.

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.