IF and AND functions request for help
Closed
mazestix
-
Sep 6, 2016 at 06:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 8, 2016 at 11:01 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 8, 2016 at 11:01 AM
Related:
- IF and AND functions request for help
- Submit request free fire - Guide
- Free fire account transfer request - Guide
- Message request on instagram disappeared - Guide
- Accessor and mutator functions c++ - Guide
- Hard disk parts and functions - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 8, 2016 at 11:01 AM
Sep 8, 2016 at 11:01 AM
Hi mazestix,
You can put your parameters in a range and then refer to those cells.
So put 1, 2, 3, 4, 6, 7, 8, 9, 11, 13 in a column like H and change your formula into: =IF(AND(B2>H2,B2<H3),"A", ... etc..
To prevent the reference of the parameters to change when dragging the formula, hit F4 when inputting/selecting the reference or manually put $ symbols in front of the row and/or column: =IF(AND(B2>$H$2,B2<$H$3),"A", ... etc..
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
You can put your parameters in a range and then refer to those cells.
So put 1, 2, 3, 4, 6, 7, 8, 9, 11, 13 in a column like H and change your formula into: =IF(AND(B2>H2,B2<H3),"A", ... etc..
To prevent the reference of the parameters to change when dragging the formula, hit F4 when inputting/selecting the reference or manually put $ symbols in front of the row and/or column: =IF(AND(B2>$H$2,B2<$H$3),"A", ... etc..
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.