Nesting IF formula problem
Closed
ESLmichael
-
Jun 28, 2015 at 08:25 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 29, 2015 at 04:29 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 29, 2015 at 04:29 AM
Related:
- Nesting IF formula problem
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jun 29, 2015 at 04:29 AM
Jun 29, 2015 at 04:29 AM
condition 1 is <1
condition 2 is <2 does this not include <1 also
perhaps what you are thinking is
aa2 between 1 and 2 then you have to use
if(and(aa2<2,aa2>=1)
if this is so change the formula
condition 2 is <2 does this not include <1 also
perhaps what you are thinking is
aa2 between 1 and 2 then you have to use
if(and(aa2<2,aa2>=1)
if this is so change the formula