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