an exact number if a number is less than

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

Guest

e.g., my inventory qty should always be 7. if inventory is at 3, i want a
formula to put a 4 in the order column. how do i do that???
 
Inventory quantity is in A1. Order cell is in B1. In B1 put
=IF(A1<7,7-A1,0). This shows 0 in the order cell if you do not need to order
anything.
If you want nothing to show instead of 0 put =IF(A1<7,7-A1,"")
 
that worked too!! THANKS Dave.

Dave Thomas said:
Inventory quantity is in A1. Order cell is in B1. In B1 put
=IF(A1<7,7-A1,0). This shows 0 in the order cell if you do not need to order
anything.
If you want nothing to show instead of 0 put =IF(A1<7,7-A1,"")
Click to expand...
 
You must log in or register to reply here.

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

Add/Subtract columns from tab to tab in same file 3
How can you replace specific characters in a string ? 2
Is there a way to extract multiple values from an INDEX result ? 3
transfer stock on condition 2
sumproduct with partial charcter matching 3
Need help creating a running subtotal 2
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
Vlookup help 2

Back
Top