Cell formula where result to be Positive only

Hi: Can anybody help a not very sophisticated used.
I need to create a formula such as A1-4500*11% where the answer is
positive. if not the answer is 0.

Example A1 =5000 therefore 500 @11%=55
Example A1=4000 therefore minus figure answer required is 0

Try this:

=IF((A1-4500)*11%<0,0,(A1-4500)*11%)

HTH,
Paul

"Freddie" <[email protected]> wrote in message
news:[email protected]...
> Hi: Can anybody help a not very sophisticated used.
> I need to create a formula such as A1-4500*11% where the answer is
> positive. if not the answer is 0.
>
> Example A1 =5000 therefore 500 @11%=55
> Example A1=4000 therefore minus figure answer required is 0
>

=max(0,a1-4500)*11%

is another way.



Freddie wrote:
>
> Hi: Can anybody help a not very sophisticated used.
> I need to create a formula such as A1-4500*11% where the answer is
> positive. if not the answer is 0.
>
> Example A1 =5000 therefore 500 @11%=55
> Example A1=4000 therefore minus figure answer required is 0

--

Dave Peterson

Try something like this:
For a value in A1
B1: =MAX((A1-4500)*11%,0)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Freddie" wrote:

> Hi: Can anybody help a not very sophisticated used.
> I need to create a formula such as A1-4500*11% where the answer is
> positive. if not the answer is 0.
>
> Example A1 =5000 therefore 500 @11%=55
> Example A1=4000 therefore minus figure answer required is 0
>
>

Thanks, works a treat