hello, i don't know much about excel but i'm guessing that it should be able to do this.
Iv'e got a column full of numbers(F), formatted so that they are currency. I'm wanting to make a column next to it that will have some formula that goes
IF F2 <= 400 THEN display F2+£30
IF F2 > 400 THEN display F2+£50
it's just a delivery charge that needs to be added on.
Thanks if anyone can help me
Alistair
Bookmarks