Forum Discussion
IF function
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
3 Replies
Mohammedadle Hi, You will need to supply conditions inside the OR Function as shown in the image below
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])
