Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |