IF function

[Mohammedadle]

Trying to use the IF function in Excel with two "logical tests" so I used the OR function as well. What I am trying to say (in excel formula) is: IF I get this "word" or this "word", use this formula ( X.Y.Z), if not, use the formula (X.Z). It works when I use one logical test (a word) but when I try to put in the other logical test (a word) It says "# Value".

Note: You can see the attached photo for reference

[#2]

@Mohammedadle 

That's like

=IF(OR([@Type]="Stairs", [@Type]="Skirt"), ...

[#3]

@Mohammedadle 

For future reference, a copy of your actual spreadsheet is more helpful than an image. Use a mockup if you need to protect confidential info.

That aside, I think you're just constructing the nested OR incorrectly. I've attached an example, but here's the formula I wrote, that does work:

=IF(OR([@Type]="A",[@Type]="B"),[@Length]*[@Pieces],[@Length]*[@Pieces]*[@Width])

[#4]

@Mohammedadle Hi, You will need to supply conditions inside the OR Function as shown in the image below