nniedzielski
Wellknown Member
 Joined
 Jan 8, 2016
 Messages
 566
 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 04.
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 04.
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