Formula help/breaking down numbers

Resolved · Urgent Priority · Version 2010

Thu 28 Nov 2013, 15:22 Delegate Katy said...

Katy has attended:
Excel Advanced course
PowerPoint Intermediate Advanced course

Formula help/breaking down numbers

Good morning

I need help with a formula, I think it needs to be an IF formula but I'm not sure.

In column A I have the number of days worked in a year. In column B, I need to look at the no of days in column A and calculate number between 41 and 120. In column C, I need to look at the no days in column A again and calculate the no of days after 121 (if there are any).

I probably haven't explained that very well! Any help would be greatly appreciated :-)

Fri 29 Nov 2013, 12:59 Trainer Alan said...

RE: Formula help/breaking down numbers

Try this, Katy:

Column B function is =IF(A1<40,"",IF(A1>120,80,A1))
Column C function is =IF(A1>120,(A1-B1),"")

These leave cells blank if less than 40 or more than 120
If you want a zero instead of a blank, type 0 instead of ""

Regards

Alan B

Fri 6 Dec 2013: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips