Cable Forum - View Single Post

MadGamer · 20-05-2005, 13:09

Ok as you've probably guessed, this is an Excel question. I need to know the IF Statement for my ICT Exam.

Here's what im using:

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

But it keeps coming up N/A in the box, so im obiously not doing something right here.

Any help appreceated, thanks

20-05-2005, 13:09	#1
MadGamer Inactive Join Date: Jun 2003 Location: Essex Age: 38 Services: Sky multiroom (Sky Q) Sky Fibre Unlimited Sky Landline Posts: 8,851	IF Statement Ok as you've probably guessed, this is an Excel question. I need to know the IF Statement for my ICT Exam. Here's what im using: =IF(C4>2000"10% Discount"),"(<2000 N/A") But it keeps coming up N/A in the box, so im obiously not doing something right here. Any help appreceated, thanks