+ Reply to Thread
Results 1 to 5 of 5

Multiplication excel code formula

  1. #1
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,123

    Multiplication excel code formula

    This code is for sum or addition
    =IF(SUM(A1:B1)=0,"",SUM(A1:B1))

    How can I do the same code to make it as
    MULTIPLICATION, SUBRACTION AND DIVISION.

    Thank you.

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    5,898

    Re: Multiplication excel code formula

    Multiplication: =IF(A1*B1=0,"",A1*B1)

    Subtraction: =IF(A1-B1=0,"",A1-B1)

    Division: =IF(A1/B1=0,"",A1/B1)

    Is this what you are looking for?

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,814

    Re: Multiplication excel code formula

    try

    =IF(A1-B1,A1-B1,0)

    =IF(A1*B1,A1*B1,0)

    Edit:


    =IFERROR(IF(A1/B1,A1/B1,0),0)


    Change 0 to "" if required

    =IF(A1-B1,A1-B1,"")
    Last edited by JohnTopley; 02-05-2018 at 04:10 PM.

  4. #4
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,123

    Re: Multiplication excel code formula

    Got it. Thank you all.

  5. #5
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    5,898

    Re: Multiplication excel code formula

    You're welcome. Glad we could help.

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

+ 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] multiplication formula in vba
    By ammartino44 in forum Excel General
    Replies: 2
    Last Post: 05-01-2015, 07:19 PM
  2. [SOLVED] Formula that goes from multiplication to plus at a set value
    By RMGHOLDUR in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-19-2014, 02:21 PM
  3. What formula to use the multiplication
    By macroashraf in forum Excel General
    Replies: 5
    Last Post: 05-24-2012, 10:36 AM
  4. VBA Looping code help need for Multiplication Table in UserForm
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-24-2011, 02:04 PM
  5. Converting simple multiplication formula in VBA code
    By Saky in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-07-2010, 07:33 AM
  6. multiplication formula in excel
    By v.muruganandam in forum Excel General
    Replies: 2
    Last Post: 07-25-2009, 01:30 AM
  7. Multiplication formula
    By yuvosh in forum Excel General
    Replies: 5
    Last Post: 03-05-2007, 08:05 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