Get product only when you have price and amount in stock

G

Guest

I have a column as price of item, in a row.
The other column has Quantity in stock, in a row.
If I have quantity only, how do I get it not to return a product in the next
cell, till I enter in the price?
Last cell in the row
 
G

Guest

Just to understand, you have:

Sample
A B C
1 Price # Product
2 $100.00 5 $500,00
3 $ 50.00 10 $500.00
4 3 $ 0
....

if you do not have price or if it's 0 the product will be zero also.

pleae feeback if I am in the correct way to try to solve you isue

regards from Brazil
Marcelo





"Clash" escreveu:
 
B

Bob Phillips

You don't say how you get a product, but logically it is

=IF(price_cell="","",get_the_product)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

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


Top