Excel IF argument
Closed
arahim01
Posts
1
Registration date
Tuesday 10 December 2013
Status
Member
Last seen
10 December 2013
-
10 Dec 2013 à 07:36
Blocked Profile - 10 Dec 2013 à 14:32
Blocked Profile - 10 Dec 2013 à 14:32
Related:
- Excel IF argument
- Excel mod apk for pc - Download - Spreadsheets
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Arrow keys not working in excel - Guide
- Excel clear formatting - 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
