If function

  • Thread starter Mitch Perala via OfficeKB.com
  • Start date
M

Mitch Perala via OfficeKB.com

If A2 minus 40 is less than zero then display zero in A15, or if A2 minus 40 is greater than 40 then run multiply A2 by 40 and display that in A15.
 
T

tjtjjtjt

Put one of these in A15.

If you don't need to account for exactly zero:
=IF(A2-40<0,0,A2*40)

If you do need to account for exactly zero and want to just return zero in
the cell, you might try something like:
=IF(A2-40<=0,0,A2*40)

tj
 

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

Adding recognised Zeros 5
Footnote references on one page, footnote text on the next 5
Excel - Wich Function should I use? 1
IF, OR and SUM function 3
NEED HELP WITH EXCEL FORMULA 3
Combining If, Vlookup in formula 2
More than 7 If Functions Example is IF(A2="Bongaigaon", B2*40, .. 2
if function, how? 4

Top