Question:

How to make an answer in excel greater than or equal to 0?

by  |  earlier

0 LIKES UnLike

ex. =(h3-3)*20 will equal a negative number if h3 is less than 0 but i want the lowest possible answer to be 0

 Tags:

   Report

2 ANSWERS


  1. Try this:

    =IF(H3<0,0,(H3-3)*20)


  2. =IF(H3<3,0,(H3-3)*20)

Question Stats

Latest activity: earlier.
This question has 2 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.