Excel Formula help

[Zonie32]

Hi. I am trying to get a formula to work:

Here's what im trying to do.. if 499.68*100% is greater than 200, than display 200. if not, then display the product of 499.68*100%

say that 499.68 = cell A2

anyone??

 

[dinger2121]

=IF(A2*1> 200,200,A2*1)

 

[onedtent]

wow... isn't anything multiplied by one the same number? or is it that i don't know math?


if your percentage is in A1 then
=IF(A2*A1>200,200,A2*A1)


_______________________________________
_______________________________________

 

[dinger2121]

sorry....copied the wrong cell's formula...

 

[AnotherHiggins]

Well, that can be used as a method of turning text to numbers.

But I'm not sure why the OP wants to check 100% of a number....

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[mintjulep]

Or simpler:

=MIN(A2, 200)