I want to next multiple IF AND statements into a shingle cell. As far as I know, I am following specific examples I have found elsewhere, so I am expecting them to work. I have tried every combination of spacing, parenthesis, etc, with no luck.
For example, I want:
cell 'MasterData!'$H$38 to return if $B$4=”BMO” & $B$18=”Complete”
OR
cell 'MasterData'!$H$20 to return if $B$4=”BMO” & $B$18=”Basic”
After these conditions work, I will need to add more.
Result: Formula is missing an opening or closing parenthesis
Result: I get “Update Values Master Data”dialog, which wants me to open another document.
Result: I get the “=” sign error
Thank you!
Bookmarks