If Function, can I use two IFS in one Cell

OK, from what it looks like this could be solved by using a LARGE function instead. From the way you worded it only one of B2 and B3 will have a non-zero value and that will always be greater than 0. So this formula could very easily give you what you want in A1:
[code]
=LARGE(B2:B3,1)
[code]


As to the title question. Yes you can nest (appropriate technical term) IF functions inside each other. This would be another valid (if more complex) way to give you the intended result using IF formulas.

[code]
=IF(B2>0,B2,B3)
[code]

Again using what you provided that one will be zero and the other not, it boils down if one is zero use the other.

I hope this helps.
~~RGrunden

FWIW you can nest 8 IF's in XL 2003 and 64 I think in post 2003 versions, although there would be more elegant solutions eventually.

@Rgrunden Did you hit the "code" icon to highlight your formulas ? If so, better advise a mod or admin, that means something is wrong. The closing should be [\code]