Problem with excel
Solved/Closed
morpheusmp
Posts
2
Registration date
Tuesday July 17, 2012
Status
Member
Last seen
July 18, 2012

Jul 17, 2012 at 03:40 PM
aquarelle Posts 7135 Registration date Saturday April 7, 2007 Status Moderator Last seen July 18, 2023  Jul 18, 2012 at 09:40 AM
aquarelle Posts 7135 Registration date Saturday April 7, 2007 Status Moderator Last seen July 18, 2023  Jul 18, 2012 at 09:40 AM
Related:
 Problem with excel
 Excel date format dd.mm.yyyy  Guide
 Number to words in excel  Guide
 Excel free download  Download  Spreadsheets
 Screenshot in excel  Guide
 Excel marksheet  Guide
4 responses
aquarelle
Posts
7135
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
July 18, 2023
491
Jul 17, 2012 at 03:52 PM
Jul 17, 2012 at 03:52 PM
Hi,
Try like this :
=IF(A2>7,A21,IF(AND(A2>5,A2<=7),A20.5,A2+0.5))
Regards
Try like this :
=IF(A2>7,A21,IF(AND(A2>5,A2<=7),A20.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
Posts
7135
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
July 18, 2023
491
Jul 17, 2012 at 11:55 PM
Jul 17, 2012 at 11:55 PM
Hi,
Try this new one :
=IF(A2>7,A21,IF(AND(A2>5,A2<=7),A20.5,A2))
Regards
Try this new one :
=IF(A2>7,A21,IF(AND(A2>5,A2<=7),A20.5,A2))
Regards
morpheusmp
Posts
2
Registration date
Tuesday July 17, 2012
Status
Member
Last seen
July 18, 2012
Jul 18, 2012 at 08:26 AM
Jul 18, 2012 at 08:26 AM
It works, thanks a lot. You have just made my life a lot easier.
aquarelle
Posts
7135
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
July 18, 2023
491
Jul 18, 2012 at 09:40 AM
Jul 18, 2012 at 09:40 AM
Happy to have been able to help you :)
Have nice day.
Have nice day.