way first.
Regards from
Tom :)
>
> From: Tinkerer
>To: users@global.libreoffice.org
>Sent: Tuesday, 18 June 2013, 11:22
>Subject: [libreoffice-users] Re: =IF Function
>
>
>DOH!
>
>Thanks all.
>I gave you a wonderful chance to poi
DOH!
Thanks all.
I gave you a wonderful chance to point out the bleeding obvious.
I tried putting the quote marks around the text and got an error result.
That was late last night so I must have done something wrong.
Tink.
--
View this message in context:
http://nabble.documentfoundation.org
IF(Test,"OK","") shows OK if Test is True and nothing (the cell is blank) if
False
Hope this helps ;)
--
View this message in context:
http://nabble.documentfoundation.org/IF-Function-tp4062008p4062015.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to:
Thank you Brian
I'd forgotten that there is a material difference between Empty cells and
Blank cells, even though I noticed that the result sometimes varied.
Tink.
--
View this message in context:
http://nabble.documentfoundation.org/IF-Function-tp4043493p4043610.html
Sent from the Users mail
I could not get your prompts to work, but they gave me ideas.
The final formula was:
=IFERROR(C30*100/B30,"")
This also covered other errors where only one number was present, so no
calculation was possible.
Many thanks, Tink.
--
View this message in context:
http://nabble.documentfoundatio