G
Guest
Has anyone been able to write an If/Then formula in Excell? (e.g. If A5=21,
then B35=10/21/04)
then B35=10/21/04)
F
Frank Kabel
Hi
in cell B35 enter
=IF(A5=21,DATE(2004,10,21),"")
in cell B35 enter
=IF(A5=21,DATE(2004,10,21),"")
F
firefytr
No. You can't write a formula that will affect another cell. You'
need to use VBA code for that
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
I thought you meant write a formula in a cell, then havit 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)
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.
another cell, and as such your formula needs to reside in the cell that you want
the data to appear in.