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...
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])