| Home |
| Search |
| Today's Posts |
|
#8
|
|||
|
|||
That so worked, thank you!
-- Rob, Teesside, UK "patrick" wrote: This error appears when the formula is dividing by 0 or a blank cell. As soon as you enter data in the formula target cell, you will get the correct result. You can eliminate the error from showing for blank cells by using an IF statement. eg. =If(A11,Your formula,"") The"" is a Null. So the IF statement reads, If A1 is not blank, then do your formula, If A1 is blank, then show a blank! This hides your #DIV/0 error. Excel is a wonderful tool and I agree the more you learn about it the less you know. Have fun with it. Pat F "abfabrob" wrote: I have indeed! Except for the #DIV/0! error. think I will just leave it in there. The cell still displays the correct answer when data is entered, so no worries. Thanks again, -- Rob, Teesside, UK "Bart Snel" wrote: I've always found that the more I know about something, the more I realise how little I know. In that light, your confusion tells me you've learned a lot today! Welcome. Bart Snel "abfabrob" schreef in bericht ... How does everyone know so much about excel? It confuses me! Thanks for your help today, -- Rob, Teesside, UK "Bart Snel" wrote: I though I was a newbie :-) Bigger than; AB means A is bigger than B. Bart Snel "abfabrob" schreef in bericht ... What does mean in a formula? -- Rob, Teesside, UK |
Threaded Mode
