Results 1 to 5 of 5

Thread: MS XLS divide IF function

  1. 24th August 2023, 08:55 AM #1
    NavyDiver's Avatar
    NavyDiver
    NavyDiver is offline Very Very Lucky! Gold Subscriber
    Join Date
    Feb 2010
    Location
    Melbourne
    Posts
    10,247
    Total Downloaded
    0

    MS XLS divide IF function

    I am trying to divide a cell IF GST is applicable to the transaction. I know I could buy or use accounting software.

    My database bias is admitted.

    =IF(E7=”Y”,B20/11,0)

    Code is giving me a name
    E7 is simple Yes/No field and is 'Y'
    B20 in this case is 7451 number field

    I thought the B20 /11 would give me 677.30. It gives me a 'NAME' result.

    I have tried =sum(IF((E7=”Y”,B20/11,0)) and sumIF(E7=”Y”,B20/11,0)

    Checked column B is formatted as Number as is Colum C where the formula and result is wanted.

    PS- I sorted by Colum E and copied the simple formula to Divide by 11 as I am late as usual.
    Reply With Quote Reply With Quote
  2. 24th August 2023, 09:16 AM #2
    Graeme
    Graeme is offline Swaggie Vendor
    Join Date
    Jan 1970
    Location
    NSW SW Slopes
    Posts
    12,033
    Total Downloaded
    0
    I can only get =IF to work correctly when the logical test is numeric rather than alpha but I haven't been able to trigger a name error.
    MY21.5 L405 D350 Vogue SE with 19s. Produce LLAMS for LR/RR, Jeep GC/Dodge Ram
    VK2HFG and APRS W1 digi, RTK base station using LoRa
    Reply With Quote Reply With Quote
  3. 25th August 2023, 07:49 AM #3
    peterjj
    peterjj is offline Fossicker Supporter
    Join Date
    Jul 2020
    Location
    Urila
    Posts
    57
    Total Downloaded
    0
    Try retyping in the double quotes, they look wrong, maybe copy pasted from somewhere with different character set(?).
    Should be "Y" not ”Y”
    ex 2008 RangeRoverSport TDV8
    ex 1995 Discovery 1 300tdi
    Reply With Quote Reply With Quote
  4. 5th September 2023, 04:22 PM #4
    NavyDiver's Avatar
    NavyDiver
    NavyDiver is offline Very Very Lucky! Gold Subscriber
    Join Date
    Feb 2010
    Location
    Melbourne
    Posts
    10,247
    Total Downloaded
    0
    Fixed it

    It is =IF(D47="yy",B47/11,0) worked for several thousand transactions
    Reply With Quote Reply With Quote
  5. 5th September 2023, 06:11 PM #5
    Graeme
    Graeme is offline Swaggie Vendor
    Join Date
    Jan 1970
    Location
    NSW SW Slopes
    Posts
    12,033
    Total Downloaded
    0
    What is in D47?
    MY21.5 L405 D350 Vogue SE with 19s. Produce LLAMS for LR/RR, Jeep GC/Dodge Ram
    VK2HFG and APRS W1 digi, RTK base station using LoRa
    Reply With Quote Reply With Quote
« Facebook Marketplace not showing seller's description | Zoom and Laptop computer external speakers »

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Search AULRO.com ONLY!
 Search All the Web!