If's and named ranges.

[NileUk]

Hi

I have a Cell B13 that is a DV list of labor types. I also have some named ranges in another sheet with the different labor costs in named ranges.

I'm trying to use a 'IF' formular in cell I13 to show the various cost's depending on the labor type chosen in the DV list in B13 as shown below but it keeps saying I have too many arguments!

=IF(AND(B13="Std Labour", "Extra Over Labour"),StdLabCost,0,IF(B13="OOH Labour",OOHLabCost,0, ))

I've created multiple IF statements befor and they worked fine, but now i'm using named ranges i'm not sure if this is the right formula to use.

Can you help.

Kind Regards

Nile

 

[Fluff]

Maybe

=IF(OR(B13={"Std Labour","Extra Over Labour"}),StdLabCost,IF(B13="OOH Labour",OOHLabCost,0))

 

[NileUk]

Maybe

=IF(OR(B13={"Std Labour","Extra Over Labour"}),StdLabCost,IF(B13="OOH Labour",OOHLabCost,0))

Hello again Fluff.

No it's not finding the OOHLabCost

 

[Fluff]

In what way?

 

[NileUk]

Fluff

I forgot to mention it was in a table. Added the table ranges and BINGO!

=IF(OR(tblEmpLabour[[#This Row],[Item Type]]={"Std Labour","Extra Over Labour"}),StdLabCost,IF(tblEmpLabour[[#This Row],[Item Type]]="OOH Labour",OOHLabCost,0))

Thanks once again.

Regards

Nile

 

[Fluff]

Glad you sorted it & thanks for the feedback.