blackisblack
New Member
- Joined
- Sep 14, 2003
- Messages
- 4
Hi People, can you help
I want to do a formula that will look at one colum and on its finding (txt based) then enter a finding (number based) in another colum. I can do it for one finding but not two.
ie =IF(A1=D1,E1,0)
A1 = Holiday
E1 = 7.5
but say if it says Half day in a1 it would put 3.75 in
sorry if this does not make sence
Andy
I want to do a formula that will look at one colum and on its finding (txt based) then enter a finding (number based) in another colum. I can do it for one finding but not two.
ie =IF(A1=D1,E1,0)
A1 = Holiday
E1 = 7.5
but say if it says Half day in a1 it would put 3.75 in
sorry if this does not make sence
Andy