View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Sumif Greater than 0

Try this.

=IF(G70,G7+(F7*0.15),F7*0.15)

Did that work?

Mike

" wrote:

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(G70+G7)

Any suggestions

Lindsey