IF

R

Ryan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell entry 2
Ttest across multiple worksheets 0
Referencing the values of multiple cells in conditinal formatting. 0
Dsum and Dmax with structured references 1
Page numbering with Merged Document and IF statements 1
need a formula 7
Formula Question 4
COUNTIF greater than one column and less than another 5

Top