A little help please?

[jefftracy]

I am trying to figure out the best way to calculate this formula. Here is what I have.

If c3 = 1 then I3 = sum of g3 *.15
if c3 = 0 then h3 = sum of g3 * .10

how would I go abot making this into a excel formula?

[jefftracy]

so i kind of got this to work but it still doesnt totally work.

=SUMIF(D3,0)+G3*$H$1
=SUMIF(D3,1)*G3*$I$1

but when i enter 1 for d3 it still calculates for h3?
when i put 0 in d3 it works?

a little confused here

[BenjieLop]

I am trying to figure out the best way to calculate this formula. Here is what I have.

If c3 = 1 then I3 = sum of g3 *.15
if c3 = 0 then h3 = sum of g3 * .10

how would I go abot making this into a excel formula?

See of this works for you. Enter in I3,

=if(C3=1,G3*0.15,if(C3=0,G3*.10,""))

Hope this is what you are looking for.

Regards.