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: [email protected]
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
