how do i have more than 7 what ifs


--
mikey
------------------------------------------------------------------------
mikey's Profile: http://www.excelforum.com/member.php...o&userid=10331
View this thread: http://www.excelforum.com/showthread...hreadid=505666

You can't - have you tried nesting formulae to reduce the amount of
'IF's required? i.e. =IF(OR(a1=1,a1=2,a1=3),"yes","No").

It really depends on what you're trying to do and the output that you
require, but usually just means a bit of lateral thinking.


--
Big Chris

Very experienced with excel in general and formulae but just started to
learn VBA....and it's hard!!
------------------------------------------------------------------------
Big Chris's Profile: http://www.excelforum.com/member.php...fo&userid=1350
View this thread: http://www.excelforum.com/showthread...hreadid=505666

Tell us what you are trying to do, there are various options.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"mikey" wrote in
message ...

how do i have more than 7 what ifs


--
mikey
------------------------------------------------------------------------
mikey's Profile:
http://www.excelforum.com/member.php...o&userid=10331
View this thread: http://www.excelforum.com/showthread...hreadid=505666

You can't - have you tried nesting formulae to reduce the amount of
'IF's required? i.e. =IF(OR(a1=1,a1=2,a1=3),"yes","No").

It really depends on what you're trying to do and the output that you
require, but usually just means a bit of lateral thinking.


--
Big Chris

Very experienced with excel in general and formulae but just started to
learn VBA....and it's hard!!
------------------------------------------------------------------------
Big Chris's Profile: http://www.excelforum.com/member.php...fo&userid=1350
View this thread: http://www.excelforum.com/showthread...hreadid=505666

i am working on a cost sheet for 12 products , to manufacture a product

u require 2 raw materials , based on the product choice the raw
material is
is directly shown .


--
mikey
------------------------------------------------------------------------
mikey's Profile: http://www.excelforum.com/member.php...o&userid=10331
View this thread: http://www.excelforum.com/showthread...hreadid=505666

Bob Phillips Wrote:
Tell us what you are trying to do, there are various options.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"mikey" wrote in
message ...

how do i have more than 7 what ifs


--
mikey

------------------------------------------------------------------------
mikey's Profile:
http://www.excelforum.com/member.php...o&userid=10331
View this thread:
http://www.excelforum.com/showthread...hreadid=505666



i am working on a cost sheet for 12 products , to manufacture a product

u require 2 raw materials , based on the product choice the raw
material is
is directly shown .


--
mikey
------------------------------------------------------------------------
mikey's Profile: http://www.excelforum.com/member.php...o&userid=10331
View this thread: http://www.excelforum.com/showthread...hreadid=505666

You probably need VLOOKUP(). How you use it depends on how your data is
organized. Check the online help and return if you need additional
help, explaining the structure of your data.

HTH
Kostis Vezerides

Hello,

I am new to these forums but stumbled accross a potential answer yesterday
while looking around. Follow the link below.

http://www.cpearson.com/excel/nested.htm

It is a very clever way around the max 7 nest issue.

Good Luck


"mikey" wrote:


how do i have more than 7 what ifs


--
mikey
------------------------------------------------------------------------
mikey's Profile: http://www.excelforum.com/member.php...o&userid=10331
View this thread: http://www.excelforum.com/showthread...hreadid=505666