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: [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
