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
Hello,

I'm trying to set up an excel quotation sheet using the following formulae

=SUM(B6*C6)+(D6*$E$3/1000)

Cell E6 = the quantity
Cell B6 = This is a manual import and can be either zero, or 1, 2, 3, 4 etch
Cell C6 = This is a static set up cost
Cell D6 = This is a cost per thousand

So for example:
(1*£250)+(£1*100,000/1,000) returns a correct cost of £350.00 (in cell E6)

The problem I'm trying to solve is that when I put in a zero in cell B6 - I want the total in E6 to also return a value of £0.00....however it still picks up static set up cost of £250.00

Any ideas please?

thanks very much

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