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

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