Formula and Condition for a Calculation to leave a zero if the res

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to generate a formual with a condition condition that if the formula
returns a negative number the resulting answer should be zero? Can anyone
help
 
Try something like this:

=MAX(your_formula,0)

Does that help?

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

XL2002, WinXP-Pro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if(iserror()) question 2
IF statement that yields a value based on a formula 6
Returning 1 of 4 values if conditions are met 4
Vlookup return Zero if not there 2
nested IF without repeating the condition? 1
Zero if zero yet blank if blank? 5
If function using cell format as the condition 2
Networkdays and misleading results from blank column 3

Back
Top