View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE
 
Posts: n/a
Default 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