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

[Dawn_L]

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 %

[#2 · Accepted 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)

[#3]

@Dawn_L 

=MIN(I9/H9*100,100)

[#4]

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

[#5]

yw :)