Spread sheet help - IF formula???

[valve90210]

Hi All

This is probably a really simple thing to do but not being someone who uses excel or open office Calc un actual fact, I'm not sure quite how to acheive what I'm hoping to do.

I am putting together a simple spreadsheet with the prices of a few items, some of which need to have VAT added to the list price, some don't.

I'd like to be able to enter the list price in one column (D) and then in the next column (E) enter 'y' or 'n'. In the column to the right (F) I'd like to be able to enter an IF formula so the spreadsheet will look at the E column, if I have entered y, it will then multiply the D colum value by 1.15 and enter the price including VAt, or if I have entered n, it'll simple put in the same value as the D column,

I thought the formula would be something along the lines of:

=IF(E3=yes,=SUM(D3*1.15),D3)

but it just gives me an error and I'm not sure why.

can anyone help me out with this?

Any help very much appreciated.

Thanks

Valve

 

[valve90210]

Thanks for your help guys, will try it this evening.

I did try it without the =Sum part but when it didn't work, I gave it a try...lol Must just have been the lack of quotation marks.

Thanks again for all the help.

Valve

 

[valve90210]

Tried that formula and it wasn't working initially, so just for info, Open Office calc requires semi colons between the sections of the formula rather than commas,

Valve