Excel Formulae - returning a zero value
Closed
Smudger1234
Posts
1
Registration date
Friday June 26, 2015
Status
Member
Last seen
June 26, 2015
-
Jun 26, 2015 at 06:32 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 26, 2015 at 08:49 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 26, 2015 at 08:49 AM
Related:
- Excel Formulae - returning a zero value
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Excel mod apk for pc - Download - Spreadsheets
- 1st, 2nd, 3rd position formula in excel - Office Software Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 26, 2015 at 08:49 AM
Jun 26, 2015 at 08:49 AM
smudger1234, Good morning.
The result of your operation is CORRECT.
But... if you want to force the result to be ZERO, try to use:
=IF(B6=0,0,SUM(B6*C6)+(D6*$E$3/1000))
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
The result of your operation is CORRECT.
But... if you want to force the result to be ZERO, try to use:
=IF(B6=0,0,SUM(B6*C6)+(D6*$E$3/1000))
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão