Help with an excel formula please...

  Major Disaster 18:57 25 Jan 2006
Locked

Hey,

Im building a spreadsheet of my ebay transactions. If you recieve payment from outside the UK the paypal charge is different from that inside the UK (boarder fees click here=)

I have a coulmn called "Payment from inside UK?" In this column i put "yes" or "no". The next column is the paypal fees. I want to do an if formula, i think, to see if that column says "yes" then do this formula for charges, if "no" then this. Here is my failed attempt.

=IF((K37=Yes,"=SUM(J37*3.4%+0.2)","=SUM(J37*3.9%+0.2)")

(Column K is my Payment from inside UK?
Column J is the price sold)

Any ideas?
Thanks for the help.

  VoG II 19:02 25 Jan 2006

=IF(K37="Yes", J37*3.4%+0.2, J37*3.9%+0.2)

  originalmiscellany 19:06 25 Jan 2006

Out of interest do you work with computers for a job or just have a vast amount of knowledge at your fingertips?
I'm always impressed by the speed and frequency you resolve queries on here!

  VoG II 19:10 25 Jan 2006

I work with computers in my job but I'm not an IT person. I use Excel quite a bit though :o)

  Quickbeam 19:11 25 Jan 2006

I noticed it took you 5 minutes to reply to this... what is the record?!

  Major Disaster 19:15 25 Jan 2006

You are amazing!

Twice now this has happened, ive asked for a formula and you've replied before i even posted the question!

Thanks again

  VoG II 19:20 25 Jan 2006

My pleasure.

By the way, your =SUM() statements were redundant.

SUM is used in formulas like

=SUM(C4:E4)

=SUM(C13,D14,E13)

=SUM(C17:C19,E17:E19)

You don't need SUM to calculate J37*3.4%+0.2

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?