Recent content by Safequip

Thank you so much that is perfect xx

So for example when I put yes into say D27 I want E27 to show the price of say £9.99 but if it says no then it should be £0.00

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

Thanks Luke

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

E61700 2 E61L5 4UK E65 2UK E65100 2 E65200 2UK E65200 2UK E65300 2 E69 P E72 ACUK E72 P E73 P E76 P E78001 E78002 E78003 E78004 E78900 E78901 E78AHB E78BHB E78CHB I have a worksheet with codes as above, I need to Prefix them so they all have LY in front of the E Hope this makes sense Thanks

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

Thanks

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

simple formual has worked don't know why I didnt think of that before, thanks for your help Throttleworks xx

Hi thanks for your speedy response I need to convert a full spreadsheet from dollar to £ using the exchange rate of 1.64 so for example $34.20 would then be £20.85 hope this makes sense

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.

Hi Sir I did as Dan said, but where I was going wrong was I wasn't using Colum "B" to type in the formula so to change all of colum A I typed = Proper (A1) into B1 and dragged to the bottom .. easy when you have the great advise of the members here and it makes me look clever to the boss

Cheers all, got it sorted... xx