Thread: If function
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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.