If value in C1 higher than 0, input "N/A" in L1

Posted by Noir on December 06, 2001 6:09 AM

I have a product purchasing spreadsheet that is broken into two sections. Section 1 is covers the 1st-14th of the month. The second section covers the 15th-end of the month. If i purchase a Hard Drive within the 1st-14th, i can just N/A the Hard drive cell for the 15th-end of month, since the requirement for the month has been fulfilled.
I would like to input a formula that would detect an entry in C1 (which is my cost cell) and automatically input a word (such as N/A) in the Hard Drive cell within section 2 (which is L1).

Thanks.
noir

Posted by Ren on December 06, 2001 6:22 AM

In cell L1, put the following formula:
=IF(C1>0,"N/A",)
What would you like the cell to display if C1 is 0? Put that after the last "," or a "0" will default.

Posted by Noir on December 06, 2001 7:00 AM

:Thanks Ren, it worked GREAT!! As far as C1 being "0", i would like to instead have it display "OPEN". Do i type "OPEN" behind the last "," with any commas, brackets,etc?

Posted by Paul on December 06, 2001 7:27 AM

Ues =IF(C1>0,"N/A","Open")

Posted by Noir on December 06, 2001 10:38 AM

Re: Ues =IF(C1>0,"N/A","Open")

:Thanks Paul.

-noir