String IF statement

[PuntingJawa]

I'm having trouble with an =If statement. If G4 is less than C3 then F4. But if G4 is greater than C3 then C4/G4. What I would like to add is if C3/G4 comes back with 0 or less than it returns as 0. Is there a way to go about this? I'm perfectly fine with any changes to formula.
My current statement
=IF(G4<C3,F4,IF(G4>C3,C3/G4)))

 

[Joe4]

Simple addition to your current formula:

=IF(G4<C3,F4,IF(G4>C3,MAX(C3/G4,0)))

BTW, you haven't accounted for the situation in with G4 and C3 are equal.
As you formula is currently written, it will return FALSE if that situation happens.

 

[PuntingJawa]

That is a great point and something I overlooked. Thank you very much for your wisdom.
The formula is now =IF(G4<C3,G4,IF(G4>C3,MAX(C3/H4,0),IF(G4=C3,G4))) which should work nicely.

 

[Joe4]

That is a great point and something I overlooked. Thank you very much for your wisdom.
The formula is now =IF(G4<C3,G4,IF(G4>C3,MAX(C3/H4,0),IF(G4=C3,G4))) which should work nicely.

Actually, if it should G4 when then are equal, which is the same as when G4<C3, then you could simply that to:

=IF(G4<=C3,G4,IF(G4>C3,MAX(C3/H4,0)))

Or even shorter, since all possibilities are exhausted (i.e. if F4 is NOT <= C3, then it has to be > C3, so there is no need to explicitly check for that).
So you can get rid of the second IF like this:

=IF(G4<=C3,G4,MAX(C3/H4,0))

for the simpliest version yet!

 

[PuntingJawa]

Even better. I can read the shorter must easier as well. Thank you again!

 

[Joe4]

You are welcome!
Glad I was able to help.