Has anyone been able to write an if/then formula in excell?

K

KirkF

Has anyone been able to write an If/Then formula in Excell? (e.g. If A5=21,
then B35=10/21/04)
 
F

firefytr

No. You can't write a formula that will affect another cell. You'
need to use VBA code for that
 
F

firefytr

Oh, oops. :( I thought you meant write a formula in a cell, then hav
it change another cell. I see Frank has got you. It's a 3 par
syntax, first being the Check, then what if True, then what if False
 
M

mathew

Hi Kirk,
In B35:
=IF(A5=21,"10/21/04","")

This puts a blank if A5 is not 21, (ie "")
Adjust to your needs
Mathew

Has anyone been able to write an If/Then formula in Excell? (e.g. If A5=21,
then B35=10/21/04)
 
K

Ken Wright

Using formulas you can only PULL data into a cell from Excel, not PUSH data into
another cell, and as such your formula needs to reside in the cell that you want
the data to appear in.
 
Top