Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
First, thank you for looking at his and your expert help and advice.
I have this Array entered formula in cell V1: =IF('Priced BOM'!$W$1<(OR((LEFT('Priced BOM'!$W$1,3)="DLA"),(LEFT('Priced BOM'!$W$1,3)="GFM"))),"Quote",'Priced BOM'!$W$1) and it give the wrong result, it evaluates to True when it should be False because W1 has the value "DLA". I need for it to say "Quote" if cell W1 does not contain the text "DLA" or "GFM" and state the value that is in W1 if it evaluates to False. Is there a way to use OR in the formula or can what I want to do just not be done? Thank you in advance for your help Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with formula in Excel | Excel Worksheet Functions | |||
Problem with formula | Excel Worksheet Functions | |||
problem with Array Formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Need a formula for this problem | Excel Worksheet Functions |