[libreoffice-users] Formatting in LO Calc

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