multi IF

[blackisblack]

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

 

[Aladin Akyurek]

=IF(A1="Half",3.75,IF(A1="Holiday",7.5,""))

 

[Brian from Maui]

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

=IF(A1=D1,E1,IF(A1=F1,G1,""))

F1= Half day
G1 = 3.75

 

[DRJ]

Try this. Put it is cell E1

If(A1="Holiday",7.5,if(A1="Half Day",3.75,false))

Change false to whatever you want the value to be if it is not holiday or half day.

Hope this helps

Jacob

 

[Iridium]

What's in D1? Can you post your sheet using the HTMLMaker lite from http://www.interq.or.jp/sun/puremis/colo/HtmlMaker.htm?