Assistance with stringing multiple IF statements

Cheryl Romano

I need to create a string of 3 IF statements and I can't seem to get it right. I have tried multiple ways of doing this and currently have the following:

=IF(ISBLANK([HowMany?]@row), 0),

IF=IF([HowMany?]@row=1), 1),

IF([HowMany?]@row), =2), 2)))

Essentially I have a field labeled HowMany? where the value will be one of blank, 1 or 2. In another field, I want to evaluate HowMany? and if it is blank, I want it to state 0 and if it is not blank, I want it to state the value from that field (either 1 or 2). Any help would be greatly appreciated. Thank you!

Cheryl Romano

Please disregard, I got it to work with this:

=IF([HowMany?]@row = 1, 1, IF([HowMany?]@row = 2, 2, 0))

Cheryl Romano

Please disregard, I got it to work with this:

=IF([HowMany?]@row = 1, 1, IF([HowMany?]@row = 2, 2, 0))

Genevieve P.

Hi @Cheryl Romano

Looks good! Thanks for posting your solution.

Cheers,

Genevieve