# Multiplication excel code formula

1. ## 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. ## 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. ## 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,"")

4. ## Re: Multiplication excel code formula

Got it. Thank you all.

5. ## 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.

#### Thread Information

##### Users Browsing this Thread

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

#### 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