Cell formula where result to be Positive only

F

Freddie

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
 
D

Dave Peterson

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

is another way.


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
Click to expand...
 
R

Ron Coderre

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

Does that help?

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

XL2002, WinXP-Pro
 
Top