## Excel2010/Win7/Arrays/ Cell A1’s content is my array e.g. {“N”,0;”Y”,1} not recognized.

Excel2010/Win7/Arrays/ Cell A1’s content is my array e.g. {“N”,0;”Y”,1} not recognized. Request/Goal: I want to enter the …

Excel2010/Win7/Arrays/ Cell A1’s content is my array e.g. {“N”,0;”Y”,1} not recognized. Request/Goal: I want to enter the …

Hello all. In the spreadsheet below I am using the values from the table and an inputted value (yellow box) inside the formula =VLOOKUP(B16,F15:G29,2,TRUE) to …

I have a price list which i need to get back to cost price, then add a margin then add vat how do i, take off 20% add 40% and add vat to all the figures in the …

=(F2*0.4)+(G2*0.4)+(H2*0.2) This formula works well for my needs; however, I want the final answer to be a rounded number with no decimal places. I need help …

I have a Age calculating formula in an excell cell, which calculates the age as on another date. The forumala is …

Hi, I have build a absence tracking wookbook but now would like to add a funtion that adds a row into my work sheet when i search and select an employees name …

Hii I have three coilumns H I J Net VAT TOTAL I need to work out how once we enter each nett it will work out the vat and total. (iideally it can …

I am trying to make a lottery checker in excel,but dont know which formula to use to make it work. My draw numbers are in cells a1 to f1 i can make the …

Hi I am trying to work out what the VAT would be in excel formatt. I have the following at the moment but i cannot seem to change it to 20% J17-SUM(J17/1.175) …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.