## Mapping Excel data

Hi, I’d like to create a mapping sheet to generate a report based on internal data and the data from the client. The problem is, the products don’t …

## HOW TO GET DESIRED OUTCOME USING EXCEL?

Hello, Don’t really know how to name this problem properly. Just made it more in a general sense rather than a specific one. Here’s the problem, …

## 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 …

## Rounding values in a VLOOKUP function

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 …

## Calculate Cost Price, Add Margin and VAT in Single Formula

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 …

## How do I add the ROUND function to an existing formula?

=(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 …

## Excel Formula working on one computer but not on another

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

## Insert Row in Excel when Searching for Employee

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 …

## Calculate Net VAT and Total

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 …

## Lottery Results Checker in Microsoft Exel

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 …

## Calculate VAT in Excel

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) …