Excel IF argument

Closed
Report
Posts
1
Registration date
Tuesday December 10, 2013
Status
Member
Last seen
December 10, 2013
-
 Blocked Profile -
Dear All,

I'm trying to use IF argument in a excel document for a calculation. But it is not working. I'm using more than 8 IF argument. My excel is Office XP. Please help me anybody.

Regards

Rahim

1 reply


Hang in there sir.

The logic for if in Excel is as follows:
=if(logic test, test is true, test is false)

With that being said, you can nest if statements, depending if you wish to fall in true or false, as in:

=if(logic_test_a,
if(logic_test_b,then_both_test_a_and_b_pass_true,false-to_logic test-b)
,false_to_logic_test_a)

I hope this helps.

//ark
-Moderator/Contributor