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

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")

Re: IF Statement
 

You want it to look like this....

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

EDIT: Beaten to it