Sumif Greater than 0

[lindsey1975]

Hi All

I can't seem to get the last bit correct,

What i am trying to do is if F7 x 15% (which is ok)
then if G7 is Greater than 0 and the figure in to the total sum



=SUM(F7*0.15)SUMIF(G7>0+G7)

Any suggestions

Lindsey

 

[Guest]

Try this.

=IF(G7>0,G7+(F7*0.15),F7*0.15)

Did that work?

Mike

 

[Bob Phillips]

Are you trying to put a formula in G7 that will check F7 and add the value
to a value already in G7?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[lindsey1975]

Hi Bob


No I am trying to put the formula in H7

Lindsey

 

[Guest]

Looking again, your own formula wasn't a million miles away. Try this in H7
as an alternative.

=SUM(F7*0.15)+SUMIF(G7,">0",G7)

Mike

 

[Bob Phillips]

Then this is probably what you want

=G7+MAX(F7*0.15,0)


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[David Biddulph]

=F7*15%+MAX(G7,0)

 

[lindsey1975]

Thankyou all

Got it working now

Lindsey