Excel IF formula question 2

[comboy]

Hi folks,
Can anyone tell me if it is possible to have more than 1 IF fuction statement in one cell.

I've got a spreadsheet in which I'm keeping stock levels of manuals. I need to be able to display different messages in a cell telling users to reprint X amount of manuals depending upon the current stock level of the manuals

So far it working great with just one IF statement e.g
=IF(C31=15,"Reprint 5 manuals","Full stock")
What I need is to able to add some thing like this:
=IF (c31=15,"Reprint 5 manuals","Full stock")+(c31=10,"Reprint 10 manuals","Full stock")in the same cell

Don't think it can be done but if anyone knows different please let me know.

Cheers,

comboy

 

[Molby]

The below should do the trick in this case

=IF(C31=15,"Reprint 5 manuals",IF(C31=10,"Reprint 10 manuals","Full stock"))

 

[Tonyjstone]

Hi Comboy,
I'm not sure if this is what you want, but nesting the statements seems to deliver the result you request.

=IF(A1=15,"Reprint 5",IF(A1=10,"Reprint 10","Full Stock"))

Naturally you will have to make the cell references relevant, and the visible statements can be adjusted.

 

[comboy]

Thanks guys,

Tried this earlier but got the syntax wrong it's working now.

Cheers,

Comboy

 

[GrayShades]

Can anyone tell me if it is possible to have more than 1 IF fuction statement in one cell."

Yes, the spec says seven nested IF statements. However, you can use named ranges and extend that up to 49 (although it is impractical!)

Check out Chips' solution to go beyond that limit of seven.

Chip Pearson

Software: XL2002 on Win2K
Humanware: Older than dirt