Search results

I have spreadsheet that has options of yes or no which dictates the end price, I want to have it auto calculate so for example if you choose the option yes it automatically shows the price but if you choose no it has a zero value. Can anyone advise on how this is done Thanks in advance again

I am currently doing a team challenge where all members have agreed to walk/run/cycle 100 miles in September, most members are sending the results in KM is there a formula I can use to quickly convert to Miles? Thanks in advance

Hi I have a worksheet that I want to prefix all existing codes with LY can you help?

How do I protect a work book from being edited by users, I still want them to be able to view but not make any amendments? Thanks

I need to format an american price list into £ using exchange rate, can anyone help?

Hi I want to round my figures up to the nearest 0.50p or £1.00 but so far I can only work out how to round to nearest 0.50p by using =CEILING(P364,0.5) anyone help me with what I'm missing? As always thanks in advance.

I know there is a formula for doing this, but for the life of me I can't remember what it its, any help is as always appreciated. Thansk

I need to protect a workbook but I'm unsure of how it's done I can see the protect workbook option but then I'm not sure... The sheet needs to viewed by others just not to be edited. Thanks

I have a price list that I need to reduce by 35% however doing cell a minus 35% doesn't give me the answer I need, clearly I'm doing this incorrectly can anyone help me with the formula I should be using? Thanks

instead of dragging a formula down a column which takes forever how do I autofill I can't work it out thanks

How do I increase column B by 20% of what is in column A? Thanks

hi how do I get my formula to the bottom of a spread sheet without having to drag it for ages. Thanks

how do you convert a price list that is in euro to £ thanks

Small - XX Large Small -X Large Small -Large Small -XX Large Small-Medium/Large Small - XX Large Small -XX Large Small -X Large need to change to S-XXL and so forth, is this possible?

I have a supplier price manual (3000 plus rows)with product numeric codes ie 12345, my own internal codes should begin with an abbreviated 3 digit alpha code ie ABC12345 does anyone know how I can change this without having to do each individually? As always your help is appreciated.

Can anyone help please I have a huge spread sheet I need to round up the pennies on, I've started to do this manually but it is going to take me till my pension and I do know that excel has the capabilities of doing this I just can't work out how and would appreciate any advise, see below, first...