98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula help/breaking down numbers
Formula help/breaking down numbers
Resolved · Urgent Priority · Version 2010
Thu 28 Nov 2013, 15:22Delegate 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:59Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Freeze Rows and Columns to keep lables displayedYou can freeze rows and columns in your worksheet so they don't move. |
