Greater than or equal to

Closed
WIL1385 - May 18, 2011 at 09:44 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 18, 2011 at 08:52 PM
Hello,

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?

I know this should be easy but i can't figure it out.

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
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.
0