Ok, I think I can eventually figure this out but I have been looking at it too long today.
Basically if cell $B4 is Bew TRUE then 1, IF cell $B4 FALSE then 2. I have the formula working independently, now I am just stuck on god forsaken brackets. I am also aware there may be better ways to do this whole thing in general, but when imagination fails brute force works.
Based on the input of a cell "if(Data Input! $B4 = "Bew" " I want then to have these two options in-cased in the initial if statement:
1:2:![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Bookmarks