+ Reply to Thread
Results 1 to 4 of 4

How do I calculate my clothes dryer demand based on if my electric range has a demand

  1. #1
    Registered User
    Join Date
    02-01-2021
    Location
    Edmonton, Alberta
    MS-Off Ver
    2012
    Posts
    12

    How do I calculate my clothes dryer demand based on if my electric range has a demand

    I am looking to have J11 multiply C11 by F11, if C4 has a number or have J11 multiply by H11, if C4 has no number.
    Last edited by HaloMike; 12-23-2021 at 02:33 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: How do I calculate my clothes dryer demand based on if my electric range has a demand

    Try this in J11:

    =IF(ISNUMBER($C$4),F11,H11)*C11

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    02-01-2021
    Location
    Edmonton, Alberta
    MS-Off Ver
    2012
    Posts
    12

    Re: How do I calculate my clothes dryer demand based on if my electric range has a demand

    This is perfect, Thank you

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: How do I calculate my clothes dryer demand based on if my electric range has a demand

    Glad to help, and thanks for the rep.

    Merry Christmas.

    Pete

+ 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. Want formulas in one specific range to calculate only on demand
    By fpt264 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2019, 12:15 PM
  2. Calculate Average Demand Intervall (ADI)
    By IndigoSK in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-18-2018, 06:20 AM
  3. inv - demand = excess - vba to calculate
    By cmcconna in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-18-2018, 09:44 AM
  4. Formula to calculate demand intervals
    By fabian_andrew in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-07-2017, 12:44 PM
  5. [SOLVED] Calculate Defined Weekly Demand Based on Current Date
    By d_striker in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-09-2013, 03:24 PM
  6. Fomula to calculate supply vs Demand - Stock
    By Achard in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 09-17-2008, 02:13 PM
  7. [SOLVED] Calculate the intersection of supply and demand curve
    By Angus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-04-2005, 11:06 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