Excel IF argument
Closed
arahim01
Posts
1
Registration date
Tuesday December 10, 2013
Status
Member
Last seen
December 10, 2013
-
Dec 10, 2013 at 07:36 AM
Blocked Profile - Dec 10, 2013 at 02:32 PM
Blocked Profile - Dec 10, 2013 at 02:32 PM
Related:
- Excel IF argument
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
1 response
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
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
