How do I write this formula

B

Bob Greenblatt

If c7 is more than 40 put the amount over 40 in c8
Click to expand...
You need to understand that a formula can only change the value of the cell
it is in. Formulas CAN NOT change the value of another cell. So, to do what
you want, put this formula in C8:
=if(c7>40,c7-40,0)

This formula will make C8 a zero if C7 is less than 40. To have C8 be blank
in this case, change the 0 in the above formula to "".
 

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

Grow/Shrink Text gradually from slide to slide 0
Footnote references on one page, footnote text on the next 5
IF argument limit - how convert formula to VBA? 2
Array formula - help with #NUM! errors 0
Permission in Outlook 0
Excel 2010 countifs for date range 3
Help with a formula for a Time Sheet. 1
Calculate per minute cost of cell phone usage 1

Top