+ Reply to Thread
Results 1 to 2 of 2

[Google Sheets] The same formula but the results are not the same in a new file.

  1. 02-08-2023, 11:08 AM #1
    nukool
    nukool is offline
    Registered User
    Join Date
    02-08-2023
    Location
    Pathum Thani, Thailand
    MS-Off Ver
    Microsoft Office 365
    Posts
    2

    [Google Sheets] The same formula but the results are not the same in a new file.

    This is my first question in this place.
    If I did anything wrong, please be apologized.

    I have 2 files, Test11 and Test12.

    In Test11, the formula of cell D5 in Sheet 'Income statements':
    =if(ISERROR(SUM(FILTER(Journal!AM:AM-Journal!AN:AN,VLOOKUP(Journal!AI:AI, Validations!D:G, 4, FALSE) = C5))),0,SUM(FILTER(Journal!AM:AM-Journal!AN:AN,VLOOKUP(Journal!AI:AI, Validations!D:G, 4, FALSE) = C5)))*-1
    and cell C5 is dbdxbrl01 .
    The result is correct.

    I made a copy of this file and renamed it 'Test12' , added some more data.
    The formula did not work and gave the result as 0.

    Is my formula wrong ?
    Attached Files Attached Files
    Last edited by nukool; 02-08-2023 at 09:50 PM. Reason: I found the answer by myself.
    Reply With QuoteRegister To Reply
  2. 02-08-2023, 10:00 PM #2
    nukool
    nukool is offline
    Registered User
    Join Date
    02-08-2023
    Location
    Pathum Thani, Thailand
    MS-Off Ver
    Microsoft Office 365
    Posts
    2

    Re: [Google Sheets] The same formula but the results are not the same in a new file.

    I have copied a range of cells from another file and pasted into new file.
    I used format showing zero value as '-'.
    After pasting into the new file, it is text '-'.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google Form Results in Google Sheets: Pulling comments if any, and listing all comments
    By Mandy7782 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 12-20-2022, 11:02 AM
  2. Google Form Results in Google Sheets: Pulling comments if any, and listing all comments
    By Mandy7782 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-20-2022, 11:02 AM
  3. Google Sheets: Results favorite (checked) entries in a new sheets
    By RaimundP in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 06-25-2022, 06:35 AM
  4. [SOLVED] Formula Parse #Error! - Excel file converted to Google Sheets
    By DHoots in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 03-04-2021, 09:58 AM
  5. [SOLVED] Google sheets script to download file and save it to google drive folder and use it's data
    By western in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 01-18-2021, 01:31 PM
  6. [SOLVED] Google sheets vba to download file and save it to google drive folder and use it's data
    By western in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2021, 08:48 AM
  7. [SOLVED] Index First Three Results That Match Criteria In Google Sheets
    By swordswinger710 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-27-2019, 05:06 PM

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 Engine Friendly URLs by vBSEO 3.6.0 RC 1