More excel questions https://www.lotterypost.com/thread/133223 Lottery Post Forum Topic: More excel questions en-us Lottery Post RSS Generator Reply #3 https://www.lotterypost.com/thread/133223/592632 https://www.lotterypost.com/thread/133223/592632 Fri, 28 Apr 2006 01:00:40 GMT lottaloot Worked perfectly!

Thanks Thoth

]]> lottaloot Reply #2 https://www.lotterypost.com/thread/133223/592243 https://www.lotterypost.com/thread/133223/592243 Thu, 27 Apr 2006 14:12:11 GMT lottaloot Thanks

I'll try that.

]]> lottaloot Reply #1 https://www.lotterypost.com/thread/133223/591474 https://www.lotterypost.com/thread/133223/591474 Wed, 26 Apr 2006 15:23:56 GMT Thoth Hmm...suppose you have a number or text in cell A1. A1 could also contain nothing. You could try this:

=IF(ISNUMBER(A1),A1, )

If A1 contains any number, excel will return that number. If the cell A1 contains text or is blank it will return nothing (because of the double quotation marks, which is the IF Not part of the formula). You could make it return whatever you wanted when there is no number in A1 by replacing the double quotation marks with a ref to another cell or by adding a

]]> Thoth More excel questions https://www.lotterypost.com/thread/133223 https://www.lotterypost.com/thread/133223 Wed, 26 Apr 2006 01:57:11 GMT lottaloot Is there a way that you can use the isnumber function in order to give the number as a results instead of true or false

]]> lottaloot