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.
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.
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?
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.
Got it. Thank you all.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks