Thread: Negative value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Negative value

If you don't want to use IF, then you can use MAX instead...

=MAX(0,<<your current formula goes here)

--
Rick (MVP - Excel)


"Felipe" wrote in message
...
How can i change the negative result of a formual into cero "0".
PS: dont want to use the If apliation.

thanks in advance.