# Archive by month February

## Formula Issues

I am trying to work out a formula to show total of £38.90per hr in column I6 when Y is inputted into column G6 and the total of hrs worked in column H6, …

## If Function – If False Do Nothing

The IF function has the following syntax: IF(logical_test,value_if_true,value_if_false) My questions is,If I don’t want the function to take any action …

## Enter a Formula to Compute Total Cost

How to compute the total cost and referring to the rate as an absolute cell

## If Functions

I have 53 week numbers along columns AE to CE In column I is the total Quantity. In column Y is the start week number – 7 in this case. In column Z is …

## calculating dates between UK dates

Hi no matter how I format the dates in Excel when i perform various date calculations to work out the number of days between dates it counts them as US

## Excel Summary Sheet

I have 2 sheet 1 called summary 2 called item In summary sheet I want excel to show me all the item with minuse number from the item sheet & i want it to …