I have 22 options. Instead of using the IF function what can I use or
can I use the IF function w/ another function? This is what I have.

Cells A1, A2, A3 and so on

This is what I started w/ the IF function:

=IF(A1=0,22,IF(A2=0,21,IF(A3=0,20 and so on

Thanks,


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=539700

Are you trying to find a value that is in a range?

Debra Dalgleish's website should get you pointed in the right direction.
See the section on the VLOOKUP function he

http://www.contextures.com/xlFunctions02.html

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=539700

A1, A2, A3 and so on is the total money from other cells, so if A1 = 0
then I want the cell to show 22, which is for the # of days left in the
month, if there is a value other then 0, go on to A2 and if A2=0 show 21
and so on.

Basically if
A1 = 0 (result 22) - if not then test A2
A2 = 0 (result 21) - if not then test A3
A3 = 0 (result 20) and so, testing each one until it finds the cell
that equals 0


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=539700

Hi. Given your example, if Rng refers to A1:A23, then perhaps this array
formula:

=23-MIN(IF(Rng=0,ROW(Rng)))

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"fastballfreddy"
<fastballfreddy.27gola_1147045801.1867@excelforu m-nospam.com wrote in
message news:fastballfreddy.27gola_1147045801.1867@excelfo rum-nospam.com...

A1, A2, A3 and so on is the total money from other cells, so if A1 = 0
then I want the cell to show 22, which is for the # of days left in the
month, if there is a value other then 0, go on to A2 and if A2=0 show 21
and so on.

Basically if
A1 = 0 (result 22) - if not then test A2
A2 = 0 (result 21) - if not then test A3
A3 = 0 (result 20) and so, testing each one until it finds the cell
that equals 0


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile:
http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=539700

...or just

=23-MATCH(0,A1:A23,0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=539700

I just wanted to thank everybody for their replies. I ended up using
the vlookup.


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=539700

=23-MATCH(0,A1:A23,0)

I like it! Thanks. :)
Another advantage your equation has is that it returns an error (#N/A) if
there are no zero's.
Thanks. :)
--
Dana DeLouis

"daddylonglegs"
wrote in message
news:daddylonglegs.27gqwm_1147048801.1232@excelfor um-nospam.com...

..or just

=23-MATCH(0,A1:A23,0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=539700