+ Reply to Thread
Results 1 to 2 of 2

Function, if calculation otherwise null

  1. #1
    Forum Contributor
    Join Date
    12-11-2018
    Location
    Zurich
    MS-Off Ver
    2016
    Posts
    130

    Function, if calculation otherwise null

    My workbook is able to change values in the textboxes and write them into the cells of a excel datasheet. There are three textboxes that have values in there and one that takes the mean of these 3 others. However there are two problems. When I leave on of the text boxes T_01, T_02, T_03 empty it should ignore these values for the average. And secondly if I type an uneven value into my text box then it does not take this values into account neither. I have uploaded an example file. To get to my problem open the userform and pick the first line in the text box. After changing the values in the text boxes press "aktualisieren"

    Best

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    371

    Re: Function, if calculation otherwise null

    1. there was no userform upon opening nor text box. 2. no "aktualisieren". I attempted to use the following formula in G5
    Please Login or Register  to view this content.
    . this seemed to work for me. I tried with empty cell d5, it worked. I copied formula down. It worked.

+ 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. [SOLVED] How to add if null function to macro?
    By AccountingJ in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-04-2018, 04:46 PM
  2. Count rows with multiple null and not null criteria
    By carlostheba in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2014, 05:16 AM
  3. Blank function/Null function for missing dates
    By knowledgeiskey in forum Excel General
    Replies: 2
    Last Post: 05-21-2010, 05:39 PM
  4. Replies: 7
    Last Post: 07-27-2006, 07:15 PM
  5. Function returning null value instead of string value
    By shivboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2006, 08:45 AM
  6. [SOLVED] Make a field null using IF function
    By lisaspb@gmail.com in forum Excel General
    Replies: 7
    Last Post: 06-20-2006, 02:10 AM
  7. [SOLVED] How do I get a Function to return Null?
    By Peter Chatterton in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-18-2006, 05:50 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1