SOLVED

How do I create an "if" statement with another formula

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3155786%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EHow%20do%20I%20create%20an%20%22if%22%20statement%20with%20another%20formula%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3155786%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20am%20trying%20to%20create%20an%20%22if%22%20statement%20in%20the%20same%20column%20of%20another%20for%20example%3A%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3DI9%2FH9%20-%20if%20this%20is%20greater%20than%20100%2C%20enter%20100%2C%20if%20not%20enter%20the%20mathematical%20%25%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F347389i670A07BF9E1263E1%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Dawn_L_0-1644602656841.png%22%20alt%3D%22%5C%26quot%3BDawn_L_0-1644602656841.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3155786%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

I am trying to create an "if" statement in the same column of another for example:

 

=I9/H9 - if this is greater than 100, enter 100, if not enter the mathematical %

 

Dawn_L_0-1644602656841.png

 

4 Replies
best response confirmed by Dawn_L (New Contributor)
Solution

@Dawn_L 

If I understood it correctly... here is a quick solution.

=IF((I9/H9*100)>100,100,"%")

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

 

@Dawn_L 

 

=MIN(I9/H9*100,100)

Thank you. That is exactly what I was looking for. I appreciate your help.