nniedzielski
Well-known Member
- Joined
- Jan 8, 2016
- Messages
- 590
- Office Version
- 2019
- Platform
- Windows
hi guys,
I am struggling to get my formula to work correctly, I have 3 If statements i am trying to layer properly and cant seem to get the formula to work right.
I have a list of data in a separate sheet with values. Values are between 0-4.
First thing: If no value in U1, then the cell returns a blank
Second thing: If all values in Training data are 4's, then the cell returns a 2
Third thing: If all values are 2 or greater (but not all four), then the cell returns a 1
This is the closest I have gotten, but it still says there is an error in the formula
What is missing from getting this thing to connect correctly?
as always, thank you so much for any help
I am struggling to get my formula to work correctly, I have 3 If statements i am trying to layer properly and cant seem to get the formula to work right.
I have a list of data in a separate sheet with values. Values are between 0-4.
First thing: If no value in U1, then the cell returns a blank
Second thing: If all values in Training data are 4's, then the cell returns a 2
Third thing: If all values are 2 or greater (but not all four), then the cell returns a 1
This is the closest I have gotten, but it still says there is an error in the formula
VBA Code:
=IF(U$1=0,"",If(countifs('Training Data'!$E$3:$E$217,"x",'Training Data'!AB$3:AB$217,"4")"2")IF(COUNTIFS('Training Data'!$E$3:$E$217,"x",'Training Data'!AB$3:AB$217,"<2")>0,"0","1"))
What is missing from getting this thing to connect correctly?
as always, thank you so much for any help