Re: #VALUE! error nesting IF function

Giganews Newsgroups
Subject: Re: #VALUE! error nesting IF function
Posted by:  fastballfreddy (fastballfreddy.27is1y_1147143601.4298@excelforum-nospam.com)
Date: Mon, 8 May 2006

ok it's been a long day, I realized what I was doing wrong, but I still
want to know if this is the best option?

Here's my formula

=IF(A1="a",A65,IF(A1="b",B65,IF(A1="c",C65,IF(A1="d",D65,IF(A1="e",E65,IF(A1="f",F65,IF(A1="g",G65)))))))

--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=33986
View this thread:http://www.excelforum.com/showthread.php?threadid=540116

Replies

In response to

#VALUE! error nesting IF function posted by fastballfreddy on Mon, 8 May 2006