Problem with excel
Solved/Closed
morpheusmp
aquarelle
- Posts
- 2
- Registration date
- Tuesday July 17, 2012
- Status
- Member
- Last seen
- July 18, 2012
aquarelle
- Posts
- 7115
- Registration date
- Saturday April 7, 2007
- Status
- Moderator
- Last seen
- June 2, 2022
Related:
- Problem with excel
- Transfer data from one excel worksheet to another automatically - Guide
- How to change date format in excel - Guide
- Excel @ in formula ✓ - Forum - Excel
- How to change author name in excel - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Forum - Excel
4 replies
aquarelle
Jul 17, 2012 at 03:52 PM
- Posts
- 7115
- Registration date
- Saturday April 7, 2007
- Status
- Moderator
- Last seen
- June 2, 2022
Jul 17, 2012 at 03:52 PM
Hi,
Try like this :
=IF(A2>7,A2-1,IF(AND(A2>5,A2<=7),A2-0.5,A2+0.5))
Regards
Try like this :
=IF(A2>7,A2-1,IF(AND(A2>5,A2<=7),A2-0.5,A2+0.5))
Regards
Your formula doesn't work the way that I would like. Maybe I need to explain what I need better.
I need a formula that will let A2 stay the same if it is 5 or lower, if it is 5.25 to 7, .50 needs to be subtracted from it and if A2 is 7.25 or greater, 1 needs to subtracted from it.
I need a formula that will let A2 stay the same if it is 5 or lower, if it is 5.25 to 7, .50 needs to be subtracted from it and if A2 is 7.25 or greater, 1 needs to subtracted from it.
aquarelle
Jul 17, 2012 at 11:55 PM
- Posts
- 7115
- Registration date
- Saturday April 7, 2007
- Status
- Moderator
- Last seen
- June 2, 2022
Jul 17, 2012 at 11:55 PM
Hi,
Try this new one :
=IF(A2>7,A2-1,IF(AND(A2>5,A2<=7),A2-0.5,A2))
Regards
Try this new one :
=IF(A2>7,A2-1,IF(AND(A2>5,A2<=7),A2-0.5,A2))
Regards
morpheusmp
Jul 18, 2012 at 08:26 AM
- Posts
- 2
- Registration date
- Tuesday July 17, 2012
- Status
- Member
- Last seen
- July 18, 2012
Jul 18, 2012 at 08:26 AM
It works, thanks a lot. You have just made my life a lot easier.
aquarelle
Jul 18, 2012 at 09:40 AM
- Posts
- 7115
- Registration date
- Saturday April 7, 2007
- Status
- Moderator
- Last seen
- June 2, 2022
Jul 18, 2012 at 09:40 AM
Happy to have been able to help you :)
Have nice day.
Have nice day.