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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

0.1 to 0.99 not recognised or calculated when results from formula 7
Sumif across a table 2
combining dates and text in a cell 1
calculating fees from other cells 1
sumifs/sumproduct 8
conditional statement using validation cell 2
Indirect function 2
A specific method for conditional averaging? 2

Top