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
|