amyfb
New member
- Joined
- Dec 18, 2020
- Messages
- 24
- Reaction score
- 0
- Points
- 1
- Location
- Southeastern PA, USA
- Excel Version(s)
- O365
I'm trying to update a single condition if statement to a two-condition statement, and need some help!
I can successfully execute an isblank() and an isnumber(find()) formula, each in separate columns.
but when I try to combine them into an if(and or and ifs(and, with xlookups,
I cannot get correct results.
i tried replace named ranges with direct cell references, but that didnt' make any difference.
I am fully puzzled why they won't work.
all ideas welcome, thanks for looking.
I can successfully execute an isblank() and an isnumber(find()) formula, each in separate columns.
but when I try to combine them into an if(and or and ifs(and, with xlookups,
I cannot get correct results.
i tried replace named ranges with direct cell references, but that didnt' make any difference.
I am fully puzzled why they won't work.
all ideas welcome, thanks for looking.