+ Reply to Thread
Results 1 to 5 of 5

Formula Not Calculating

  1. 10-20-2022, 10:24 AM #1
    Weebs21
    Weebs21 is offline
    Registered User
    Join Date
    11-07-2018
    Location
    Indiana
    MS-Off Ver
    Office 365
    Posts
    22

    Formula Not Calculating

    Hello,

    This is probably a simple fix that I am overlooking, but I am very frustrated. I am trying to get the formula in row 25 to calculate. I need it to calculate when there are numbers present in rows 15-24. If there is nothing in those rows, then it needs to be blank. Simple, right? Well, those rows are calculated as well so when they don't have a return, they are blank. I can't get that formula in row 25 to calculate since they are calculated blanks. I just can't seem to figure it out for some reason. Any and all help is greatly appreciated. I've attached the file I am working on as well. It's the MILK SHEET tab.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-20-2022, 10:41 AM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,676

    Re: Formula Not Calculating

    Replace quotes in you formulas with 0

    =IF('PASTE IN'!D6+'PASTE IN'!D11/2+'PASTE IN'!D16+'PASTE IN'!D21/2=0,0,'PASTE IN'!D6+'PASTE IN'!D11/2+'PASTE IN'!D16+'PASTE IN'!D21/2)

    The IF part is redundant: you can hide ) by formatting as

    0;-0;;@
    Last edited by JohnTopley; 10-20-2022 at 10:46 AM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 10-20-2022, 10:44 AM #3
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Formula Not Calculating

    It doesn't like the null strings - the ""

    Change the formulae to :

    =IF('PASTE IN'!D6+'PASTE IN'!D11/2+'PASTE IN'!D16+'PASTE IN'!D21/2=0,0,'PASTE IN'!D6+'PASTE IN'!D11/2+'PASTE IN'!D16+'PASTE IN'!D21/2)

    You can hide the zeros, if you don't like them by applying a custom format to the cells (CTRL -1 Custom and Type:
    #,##0;-0;;@

    see file.
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  4. 10-20-2022, 12:06 PM #4
    Weebs21
    Weebs21 is offline
    Registered User
    Join Date
    11-07-2018
    Location
    Indiana
    MS-Off Ver
    Office 365
    Posts
    22

    Re: Formula Not Calculating

    Thank you both! It worked.
    Reply With QuoteRegister To Reply
  5. 10-20-2022, 12:07 PM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Formula Not Calculating

    You're welcome.


    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
    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. [SOLVED] Excel formula shown as formula string not calculating (JDE downloaded)
    By lynnsong986 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2022, 10:05 PM
  2. Stop formula from calculating if criteria is meet and keep the last data of formula calc.
    By vivis in forum Excel General
    Replies: 0
    Last Post: 10-14-2015, 03:10 AM
  3. Need help with YTD formula in calculating
    By datavalidator in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-09-2014, 06:35 PM
  4. Need formula in calculating SLA
    By Techy321 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-06-2014, 01:31 PM
  5. [SOLVED] Formula not calculating
    By girishkini in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-23-2013, 12:15 PM
  6. Formula isn't calculating
    By SandyMac6614 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-16-2013, 11:01 AM
  7. macro trigger based on the result of a formula (whenever the formula for calculating)
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2013, 11:05 AM

Tags for this Thread

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