I'm new to formulas in google sheets but doing ok with online learning. I have come across something I need to do that I cant find a solution for.

I have this that works:

=if(O13>=Q14,O13-INFO!L5*O13,0)

But now I need to also include a cap to the returned value so if it reaches a certain number it will stop and return no more than a value found in another cell (in this case it would be "INFO!M5").

Is this possible within the same formula and if this type of thing has a certain name for phrase I don't know, is that why I cant find help on it.

Thanks Adam

CodePudding user response：

try nested-if:

=IF(O13>=Q14, IF((O13-INFO!L5*O13)<=INFO!M5, O13-INFO!L5*O13, INFO!M5), 0)

update:

=IF((G7>=0)*(G7<=I7), G7-G7*K7, M7 )