Adding an Argument to a Formula to check for text.

[BraydenMSB]

My current formula looks like this
=IF(OR(AND(ISBLANK('Order Sheet'!AR12),ISBLANK('Order Sheet'!AR14),ISBLANK('Order Sheet'!AR15),NOT(ISBLANK('Order Sheet'!AR13))),B3>24),"INCLUDED",IF(B17="YES",INDEX($W$81:$AM$81,1,MATCH(B4,$W$80:$AM$80,-1)),IF(B17="Yes - Coastal",2*INDEX($W$81:$AM$81,1,MATCH(B4,$W$80:$AM$80,-1)),0)))

I am looking to add an argument to this function to check for an X in a box on another page, if that is checked, it will go by the pricing of the "Yes" arguments, if not, it will go by the "Yes - Coastal" Arguments.
=if('Order Sheet'!AR13:AT13="X",INDEX($W$81:$AM$81,1,MATCH(B4,$W$80:$AM$80,-1)
This would be followed by the Index function following the "Yes - Coastal" Currently. I am confused as to why I cannot add this argument myself, I'm not sure where my syntax errors lie, but I would love some input from you all, thanks! Please just let me know if I'm missing a comma or parenthesis somewhere, I feel like this one is an easy fix, i'm just overcomplicating it.
P.S. I am still learning Excel Formulas so please feel free to go as in depth as you want, I'm always looking to expand my knowledge!

 

[petertenthije]

I am assuming that ‘order sheet’!AR13:AT13 is a merged cell?
Instead of using ‘order sheet’!AR13:AT13 in your formula, just use ‘order sheet’!AR13 in your formula.

Another tip, to make your formulas more easily readable: with ctrl-Enter you can add new rows in your formula without it loosing its functionality.

 

[BraydenMSB]

I am assuming that ‘order sheet’!AR13:AT13 is a merged cell?
Instead of using ‘order sheet’!AR13:AT13 in your formula, just use ‘order sheet’!AR13 in your formula.

Another tip, to make your formulas more easily readable: with ctrl-Enter you can add new rows in your formula without it loosing its functionality.

It is indeed a merged cell, I will go ahead and change that portion to just "AR13"

As for that tip, thank you, I did not know that!