Feb 11 2022 10:07 AM
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 %
Feb 11 2022 10:33 AM
SolutionIf 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.
I know I don't know anything (Socrates)
Feb 11 2022 10:35 AM
Feb 11 2022 10:36 AM
Feb 11 2022 10:33 AM
SolutionIf 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.
I know I don't know anything (Socrates)