Easiest way to add inventory status on my site - please help

[astei2]

I'm using an EXCEL Table of item #'s - prices - stock status (Yes or No) fields. Have saved the file as html
and uploaded to site. My question is how do I reference
the table from each individual product being sold so it
returns a value of IN STOCK "yes" or "no".

Any help would be appreciated. Thanks.

 

[paulovey]

Hi,

I am assuming that each stock item has a field that displays the total in stock.

So therefore you could refrence that cell in a if statment

@IF(A1>0,"YES","NO&quot

Paul

 

[Dreamboat]

Change Paul's formula to the following and it may work:

=IF(A1>0,"YES","NO&quot

(I can tell that Paul prefers Lotus, hee hee!)


techsupportgirl@home.com

http://www.wedomanuals.com

 

[astei2]

The formula you both provided is exactly what I need. However, I'm new to Excel, so I thought that a more thorough explanation of what I want to do and how to do it is in order.

I have uploaded the excel table containing the fields: Item # - Price - Amount in Stock
to my site to a page (such as) mysite.com/stock.htm

On all product pages (such as) mysite.com/clocks.htm (a page where a product is sold).............

What is the exact syntax I would use to reference the item of each product being sold and being looked up on the stock table at mysite.com/stock.htm and how do I reference it?

I'm using Frontpage and not sure how the formula is put into each page - can I just paste the formula into the html code of each page I wish to have an IN STOCK Status of?

Thanks for your responses and hope to hear from you again.

 

[Dreamboat]

E

http://wwwww!

You're talking something different altogether now, astei2. Sorry, I'll bow out.


techsupportgirl@home.com

http://www.wedomanuals.com

 

[astei2]

I guess my 1st post wasn't explained enough about what I'm trying to do - But your formula did help (as I said before, I'm new to Excel). Thanks for your help Dreamboat. Paulovey? are u knowledgeable in this area? Can anyone else help me with this?

 

[paulovey]

astei2,

Sorry, all I know about web pages is that you get them on the internet..???? So I will have to bow out as well. You may do better posting the same question on the web programmers forum...

And yes Dreamboat has got it, I come from a Lotus background. Really sorry about that

Good Luck,

Paul

 

[Dreamboat]

Don't be sorry, Paul!!


techsupportgirl@home.com

http://www.wedomanuals.com