Not sure where to put OR in an IF/AND/OR Formula

[gjjh25]

I have the below formula that works fine, but I know want to add an OR statement for "Vibro" along with the "Piled"

=IF(AND(D23="Piled",$F$5="yes"),(((('Plot Measure'!X23+4)*('Plot Measure'!Y23+4))*'Construction Details'!P23)*$F$9),0)

So it would be "Vibro" on D23 and also $F$5 would still need to be a "Yes".

If anyone could help please.

[Fluff13]

How about

Please Login or Register  to view this content.

[gjjh25]

Thanks for that, yes it works, just needed to ad " after vibro.

Thanks for the help.

[Richard Buttrey]

Hi

=IF(AND(OR(D23="Piled",D23="Vibro"),$F$5="yes"),'Plot Measure'!X23+4*'Plot Measure'!Y23+4*'Construction Details'!P23*$F$9,0)

Please remember next time to upload the actual workbook so that we don't have to recreate what you have to test a solution.

You can also remove some of the (((

[Fluff13]

Thanks for the help.

You're welcome & thanks for the feedback.