Excel help, need to muliply and add one cell

March 4, 2010 at 06:11:03
Specs: Windows 7
Need help to muliply and add in one cell then
to total in another.

So when I enter the number 30 into cell C5 I
need

30*.1045 + 1.6 = 4.735 Then I need the
4.735 to show in D5

But If I enter 0 in C5 it will show 1.6 in D5 I need to figure out a way so that when I enter 0 it will show 0 in D5 and not 1.6 but i I enter 1 it needs to show 1.7045

Thanks for the help


See More: Excel help, need to muliply and add one cell

Report •


#1
March 4, 2010 at 07:04:32
Hi,

Use an IF() statement to test if C5 contains 0
If it contains 0 return 0
else do the calculation

In cell D5 put this

=IF(C5=0,0,C5 *0.1045 + 1.6)


Regards


Report •
Related Solutions


Ask Question