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
|