calculating fees from other cells

S

Skills

Hi

I tried that but it still seems to be adding the 0.2 even if the sol
column is "N"

=IF(D6="N",0,(F6+I6)*3.4%)+0.2

Any ideas?

Thank
 
G

Gord Dibben

Skills

Try this change to your formula. Note the parens changes.

=IF(D6="N",0,(F6+I6*3.4%)+0.2)


Gord Dibben Excel MVP
 
Top