G
Guest
Is there a way to input more than 2 functions for the IF command...
ie. =IF(B1=0, C2=1) or IF(B1=1, C2=2) or IF(B1=2,C2=3) etc.
I'm trying to design a template that has to apply to at least three
different sources of data, and I just want to have to enter a number, and
have excel fill in the rest to scan through each different data set.
ie. =IF(B1=0, C2=1) or IF(B1=1, C2=2) or IF(B1=2,C2=3) etc.
I'm trying to design a template that has to apply to at least three
different sources of data, and I just want to have to enter a number, and
have excel fill in the rest to scan through each different data set.