Thread: IF Statement
View Single Post
Old 20-05-2005, 13:11   #2
bmxbandit
Inactive
 
bmxbandit's Avatar
 
Join Date: Oct 2004
Location: Nottingham
Posts: 1,405
bmxbandit has reached the bronze age
bmxbandit has reached the bronze agebmxbandit has reached the bronze agebmxbandit has reached the bronze agebmxbandit has reached the bronze agebmxbandit has reached the bronze agebmxbandit has reached the bronze agebmxbandit has reached the bronze agebmxbandit has reached the bronze agebmxbandit has reached the bronze agebmxbandit has reached the bronze agebmxbandit has reached the bronze agebmxbandit has reached the bronze age
Re: IF Statement
i assume you want:

=IF(C4>2000,"10% Discount","N/A")

format is

IF(logical statement,"text if true","text if false")
bmxbandit is offline   Reply With Quote