+ Reply to Thread
Results 1 to 15 of 15

Return formula when cell not empty

  1. 05-05-2022, 07:43 AM #1
    Mcfg007
    Mcfg007 is offline
    Registered User
    Join Date
    03-15-2018
    Location
    UK
    MS-Off Ver
    2013
    Posts
    14

    Return formula when cell not empty

    HI

    I would like help to return a formula when cell not empty.

    my formula is =SUM(F2*5/100)

    so i want to calculate the 5% of a value when entered on the cell, when not to remain blank.

    Thanks
    Reply With QuoteRegister To Reply
  2. 05-05-2022, 07:45 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Return formula when cell not empty

    Try this:

    =IF(F2="" "",F2*5/100)

    You don't need the SUM function.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 05-05-2022, 08:04 AM #3
    Mcfg007
    Mcfg007 is offline
    Registered User
    Join Date
    03-15-2018
    Location
    UK
    MS-Off Ver
    2013
    Posts
    14

    Re: Return formula when cell not empty

    Hi AliGW it gives me an errorAttachment 779386
    Reply With QuoteRegister To Reply
  4. 05-05-2022, 08:08 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Return formula when cell not empty

    Sorry! Comma missing:

    =IF(F2="","",F2*5/100)

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
    Reply With QuoteRegister To Reply
  5. 05-05-2022, 08:14 AM #5
    Mcfg007
    Mcfg007 is offline
    Registered User
    Join Date
    03-15-2018
    Location
    UK
    MS-Off Ver
    2013
    Posts
    14

    Re: Return formula when cell not empty

    Sorry, still gives an error
    Reply With QuoteRegister To Reply
  6. 05-05-2022, 08:29 AM #6
    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
    28,193

    Re: Return formula when cell not empty

    Please see yellow banner on how to attach a sample workbook.

    What error ?
    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
  7. 05-05-2022, 08:33 AM #7
    Mcfg007
    Mcfg007 is offline
    Registered User
    Join Date
    03-15-2018
    Location
    UK
    MS-Off Ver
    2013
    Posts
    14

    Re: Return formula when cell not empty

    Not sure what the error is see sheet attached

    Many thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 05-05-2022, 08:39 AM #8
    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
    28,193

    Re: Return formula when cell not empty

    Where is formula / error ?
    Reply With QuoteRegister To Reply
  9. 05-05-2022, 08:47 AM #9
    Mcfg007
    Mcfg007 is offline
    Registered User
    Join Date
    03-15-2018
    Location
    UK
    MS-Off Ver
    2013
    Posts
    14

    Re: Return formula when cell not empty

    The formula is to go to cell H2 to calculate 5% of cell F2 when is not blank
    Reply With QuoteRegister To Reply
  10. 05-05-2022, 08:51 AM #10
    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
    28,193

    Re: Return formula when cell not empty

    in H2 of "January"

    =IF(F2="","",F2*0.05)

    Same as Ali's formula so what does not work?
    Reply With QuoteRegister To Reply
  11. 05-05-2022, 08:56 AM #11
    Mcfg007
    Mcfg007 is offline
    Registered User
    Join Date
    03-15-2018
    Location
    UK
    MS-Off Ver
    2013
    Posts
    14

    Re: Return formula when cell not empty

    Attachment 779390 see attached.
    Reply With QuoteRegister To Reply
  12. 05-05-2022, 08:58 AM #12
    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
    28,193

    Re: Return formula when cell not empty

    Cannot see attachment: post FILE with your formula and showing error!
    Reply With QuoteRegister To Reply
  13. 05-05-2022, 09:03 AM #13
    Mcfg007
    Mcfg007 is offline
    Registered User
    Join Date
    03-15-2018
    Location
    UK
    MS-Off Ver
    2013
    Posts
    14

    Re: Return formula when cell not empty

    Excel does not allow to save it with an error. please see image attached.Attachment 779392
    Reply With QuoteRegister To Reply
  14. 05-05-2022, 09:08 AM #14
    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
    28,193

    Re: Return formula when cell not empty

    I cannot view the attachment: what is the ERROR message?

    See attached file:
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  15. 05-05-2022, 09:11 AM #15
    Mcfg007
    Mcfg007 is offline
    Registered User
    Join Date
    03-15-2018
    Location
    UK
    MS-Off Ver
    2013
    Posts
    14

    Re: Return formula when cell not empty

    It worked many thanks.
    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 to return last non-empty cell
    By IvanRama21 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-03-2020, 09:33 AM
  2. How to get array formula to return an empty cell instead of 00-Jan-00
    By Motox in forum Excel General
    Replies: 4
    Last Post: 02-20-2012, 04:50 AM
  3. Excel 2007 : VLOOKAllSheets formula return 1 or empty cell
    By zoukah in forum Excel General
    Replies: 2
    Last Post: 10-07-2009, 07:59 PM
  4. Formula Return result from non empty cell
    By innocent_eyes in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2008, 03:23 AM
  5. [SOLVED] modifying this formula to return an empty cell
    By Outbacker in forum Excel General
    Replies: 3
    Last Post: 08-22-2006, 03:10 PM
  6. [SOLVED] return an EMPTY cell in an IF formula
    By JJN in forum Excel General
    Replies: 3
    Last Post: 02-10-2006, 12:20 PM
  7. formula/macro to return last non empty cell in a specified row
    By neowok in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2005, 10:32 AM

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