Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

Weitz · 08-03-2017, 01:13 PM

Thanks for the help guys!

I am trying the nested way there, and I can't seem to get it to work.

this is my formula:

=IF(1,$O$117,IF(2,$O$118,IF(3,$O$119,IF(4,$O$120,I F(5,$O$121,IF(6,$O$122,0))))))

All it returns is the value for 1.

Sorry I am awful with excel.

Wait I just realized it doesn't make sense ha.

Cool Got it to work with this:

=IF(N4=1,$O$117,IF(N4=2,$O$118,IF(N4=3,$O$119,IF(N 4=4,$O$120,IF(N4=5,$O$121,IF(N4=6,$O$122,0))))))

08-03-2017, 01:13 PM	#36
Weitz Franchise Player Join Date: Mar 2013 Exp:	Thanks for the help guys! I am trying the nested way there, and I can't seem to get it to work. this is my formula: =IF(1,$O$117,IF(2,$O$118,IF(3,$O$119,IF(4,$O$120,I F(5,$O$121,IF(6,$O$122,0)))))) All it returns is the value for 1. Sorry I am awful with excel. Wait I just realized it doesn't make sense ha. Cool Got it to work with this: =IF(N4=1,$O$117,IF(N4=2,$O$118,IF(N4=3,$O$119,IF(N 4=4,$O$120,IF(N4=5,$O$121,IF(N4=6,$O$122,0)))))) Last edited by Weitz; 08-03-2017 at 01:19 PM.