Re: [libreoffice-users] Formatting in LO Calc

Hi Vince,

As I'm sure you know by now, your post emerged through the list virtually unreadable. You may have 
tried to attach a Calc file and learned that the list does not accept attachments. If the question 
cannot be adequately phrased in plain text without the Calc file, I think you have two options:
- Upload your file to a server to which you can provide a link in your post, or
- Try asking  your question at ask.libreoffice.org, which has more format flexibility.

Kind regards,
John

On 2026-02-09 16:24, Vince@Verizon wrote:
> I don't know if this has already been sent to the email list; I think I used an incorrect email 
> when making my first attempt to send and I have not seen any reply.  So, I am trying again. ....
> ______________________________________________________________________
>
> Hi:
>
> I have a spreadsheet in Version: 25.8.3.2 (X86_64)
> Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
> CPU threads: 32; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win
> Locale: en-US (en_US); UI: en-US
> Calc: threaded
>
> as shown below:
>
>
>
>     C     D     E     F     G     H     I     J     K     L M
> 12
>     *LEVY DESCRIPTION*     *EXEMPT
> CODE*     *% OF
> CHANGE*     *TAXABLE VALUE
> ADJUSTED BY
> EXEMPTION*     *TAX RATE
> PER 100*     *TAX
> AMOUNT*     *
> *     *1st Half*     *2nd Half*
>
> 13
>     SCHOOL TAX     $4,119.05     of Total Bill
> 14
>     SC007     School Dist. -     VS     2.05     1,560 239.2368     *$3,877.00 *
>     $1,938.50     $1,938.50
>
> ...
>     LD007     Library Tax -     V     1.24     2,620 9.2386     $242.05
>     $121.03     $121.03
>
> ...
>     COUNTY TAX     $-     of Total Bill
>
>
>     D001     County General Fund     V     0     0     2.2238 $-
>     $-     $-
>
>
>
>     D003     County Police     V     0     0     40.3471 $-
>     $-     $-
>
>
>
>     D001S     Tax     V     0     0     0.1686     $-
>     $-     $-
>
>
>
>     D002     Out of County Tuition     V     0     0 1.3881     $-
>     $-     $-
>
>
>
>     TOWN TAX     $460.05     of Total Bill
>
>
>     D005     Town Tax     V     0     0     23.6672     $-
>     $-     $-
>
>
>
>     D004     Highway Tax No. 1     V     7.63     0 12.0992     $-
>     $-     $-
>
>
>
>     GA000     Refuse Imp.- Disposal Charge     n/a     n/a n/a     n/a     $432.80
>     $216.40     $216.40
>
>
>
>     D055     Lighting Dist. - Town     n/a     0     3,120 0.8734     $27.25
>     $13.625     $13.625
>
>
>
>     OTHER TAX     $381.66     of Total Bill
>
>
>     D007      State Real Prop Tax Law     V     -34.58     0 3.0828     $-
>     $-     $-
>
>
>
>     D006     Town Outside Villages     V     0     0 5.9905     $-
>     $-     $-
>
>
>
>     D008      Central Fire Alarm Tax     V     8.13     0 0.8126     $-
>     $-     $-
>
>
>
>     D019     Fire Dept     n/a     2.48     3,120     12.2327 $381.66
>     $190.83     $190.83
>
> ...
>
>      MTA Tax
>
>
>
>
>
>
>
>
>
> 32
>     PAYMENT DUE
>
>     1st Half     2nd Half
>
> 33
>
>     _
> _
>
>     */Make Payment of: /*     *$4,960.76 *     *
> *     *$2,480.38*     *$2,480.38*
>
>
>
>     *_
> _*     *_
> _*     *_
> _*     *_
> _*
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> I am not satisfied with the display of "$-" within the I, K, and M  columns and in particular 
> within cell I16. I want the calculated result to be $0.00 whenever the value that is within the G column is 
> greater than 0.
>
> The result in cell I16 should be $0.00. My attempts to make use of IF-THEN have failed.
>
> Please help me to understand the correct Calc function to use.
>
> TNX.
>
> VinceB.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy