Greater than or equal to
Closed
WIL1385
-
May 18, 2011 at 09:44 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 18, 2011 at 08:52 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 18, 2011 at 08:52 PM
Related:
- Greater than or equal to
- How To Make an Excel Sheet Equal to Another ✓ - Excel Forum
- Format cell if equal to another cell ✓ - Excel Forum
- 1 percentage is equal to how many paise - Office Software Forum
- Excel if cell equal to multiple values ✓ - Excel Forum
- How to equalize volume of mp3 songs - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
May 18, 2011 at 08:52 PM
May 18, 2011 at 08:52 PM
here is the problem: IF(F4<=D4 ANDOR D4<=F4 THEN G4= LOWER SUM/NUMBER.
how do it get G4 to equal the number that is <= to F4 OR D4 in cell G4? "
condition F4<=D4 and/or D4<=F4 is confusing. doe that mean whatever be D4 or F4
second part
G4 <=F4 or D4
suppose F4 is 2 and D4 is 3
2 is lesser of the two.
do you want 2 or less than 2 does it mean 1, o,-1,-2 infinite possibilites.
rethink and explain your logic in a structured manner. giving examples.
how do it get G4 to equal the number that is <= to F4 OR D4 in cell G4? "
condition F4<=D4 and/or D4<=F4 is confusing. doe that mean whatever be D4 or F4
second part
G4 <=F4 or D4
suppose F4 is 2 and D4 is 3
2 is lesser of the two.
do you want 2 or less than 2 does it mean 1, o,-1,-2 infinite possibilites.
rethink and explain your logic in a structured manner. giving examples.