help on a formula

Giganews Newsgroups
Subject: help on a formula
Posted by:  WYN
Date: Tue, 27 Jun 2006

hello all, i have a database with all my invoices and their dollar totals in
column b.what i want to do is if in colunm a1 i enter the word open then the
corresponding invoice total b1 will be $00.00.any help will be
appreciated.thanks wyn