PuntingJawa
Board Regular
- Joined
- Feb 25, 2021
- Messages
- 140
- Office Version
- 365
- 2019
- Platform
- Windows
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)))
My current statement
=IF(G4<C3,F4,IF(G4>C3,C3/G4)))