Greater than or equal to

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

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