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

Cell formula where result to be Positive only
 

Try this:

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

HTH,
Paul

"Freddie" wrote in message
oups.com...
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

Cell formula where result to be Positive only
 

=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

Cell formula where result to be Positive only
 

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

Cell formula where result to be Positive only
 

Thanks, works a treat