+ Reply to Thread
Results 1 to 7 of 7

Ignoring Blank Cell

  1. #1
    Registered User
    Join Date
    05-11-2021
    Location
    England
    MS-Off Ver
    Office 16
    Posts
    4

    Ignoring Blank Cell

    Hello,

    I am using the formula =MROUND(E31/E40*1000,10) but I need it to ignore one of the cells if they are blank but still carry out the formula after the cells, I am not great with Excel so any help would be appreciated.

    Thanks!

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,111

    Re: Ignoring Blank Cell

    Please clarify.

    As stated the formula is not using a range of cells unless E31 or E40 refer to a range.

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    05-11-2021
    Location
    England
    MS-Off Ver
    Office 16
    Posts
    4

    Re: Ignoring Blank Cell

    Richard,

    Thanks for your reply, I have attached a copy with just the cells I need the formulas sorted out on which is E35, There is two boxes on the sheet one is E31 and the other is E32, there is formula in E40 which is worked out from both E31 and E32.

    I basically need E32 to be ignored from the formula if it is blank and for E31 to be *1000 to the nearest 10 still if it is blank.

    Thanks!
    Attached Files Attached Files

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,111

    Re: Ignoring Blank Cell

    ...would you give an example. For instance if E31 is 95 what do you expect in E35

    ...and if E32 contains say 25 what then?

  5. #5
    Registered User
    Join Date
    05-11-2021
    Location
    England
    MS-Off Ver
    Office 16
    Posts
    4

    Re: Ignoring Blank Cell

    I am going to change the numbers but if I had for example 2.452 in E31 with nothing in E32 I would expect 2450 in E35(sum of 2.452*1000 rounded to the nearest 10)

    If I had 2.452 in E31 and 1.456 in E32 I would expect 2460 in E35 (sum of E31-E32/0.998)

    I just want it to ignore the Sum in E40 if there is nothing in E32 and just work out the sum on the first line of this reply but then work out the second line if there is an input in E32.

  6. #6
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,111

    Re: Ignoring Blank Cell

    One way

    =MROUND(IF(E32="",E31*1000,E31/((E31-E32)/998)),10)

    This doesn't need M40

  7. #7
    Registered User
    Join Date
    05-11-2021
    Location
    England
    MS-Off Ver
    Office 16
    Posts
    4

    Re: Ignoring Blank Cell

    That worked perfectly!

    Thank you so much for you help!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem in ignoring error or blank cell in line chart
    By hiXtori in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-07-2020, 05:23 PM
  2. Chart ignoring whole row when first cell is blank
    By Reillob in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2017, 09:49 AM
  3. Replies: 2
    Last Post: 07-26-2017, 12:14 AM
  4. Ignoring a blank date cell
    By icewithaslice in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-23-2015, 02:19 PM
  5. Ignoring rows with a blank cell in one column
    By twomack1 in forum Excel General
    Replies: 11
    Last Post: 11-12-2014, 03:49 PM
  6. Ignoring Blank Cell w/ Conditional Formatting
    By AlanH in forum Excel General
    Replies: 5
    Last Post: 11-08-2012, 01:31 PM
  7. Move next value to the desired cell in a row ignoring blank cells in between
    By saeed9313 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2012, 09:29 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1