Excel formula

[flipper]

help please

Can someone help with an excel formula I am struggling with. I want to return a formula from two cells next to each other with numbers in which ever is the greatest I want it to return the name of that cell which is in the cell previous to it i/e text. The formula I have which works is =IF(B12>B13,A12,A13) with the exception that when that cell is blank it still returns a result. How do I get this formula only to return the text name in A12 or A13 only when a number is put into the cells B12 or B13.

Also can any one tell me how to return a random formula from a group of say 32 cells with names in. I then want to randomly select them all and put them in a different order in a different place I/e like when making a draw for a cup completion but all the names are the same but you want them to play different people next time around

Flipper

[Scarecrow Man]

You could use an ELSE statement, so when your IF statement is not true, it will default to something else, but I am not sure if this is accepted by Excel. You may need to word it differently.

As for the random question, I cannot answer that, but I have found a lot of Excel help from this site. http://www.mrexcel.com/

I also found this - http://www.exceltip.com/ and http://www.ozgrid.com/Excel/

Microsoft also has a complete list of Every Excel formula, here - http://office.microsoft.com/en-ca/sharepoi...1711171033.aspx

[Alan2273]

If you make a post to this thread he will guve you an answer.

http://forum.computertrouble.co.uk/viewtop...&highlight=

[10west]

ISNONTEXT func t or f

ISNUMBER func