Excel 2010; Need help w/If, Then formula
Closed
tmsblevis
Posts
1
Registration date
Wednesday June 5, 2013
Status
Member
Last seen
June 5, 2013
-
Jun 5, 2013 at 03:17 PM
Blocked Profile - Jun 5, 2013 at 04:14 PM
Blocked Profile - Jun 5, 2013 at 04:14 PM
Related:
- Excel 2010; Need help w/If, Then formula
- Microsoft office 2010 free download - Download - Office suites
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Microsoft publisher 2010 free download - Download - Publishing
- Pdf and xps add in 2010 - Download - Other
1 response
Good afternoon, The excel "if then" statement if structured as such....
=if(logical condition to check, true, false)
If you wish to loop if/then, then nest it in the false portion and make a second test for logic....so something like...
=if(E1=1,"e1=1",if(E1=2,"E1=2","E1 is not 1 or 2"))
This would be a formula in a cell, not a VBA macro.
Think it through based on the example.
=if(logical condition to check, true, false)
If you wish to loop if/then, then nest it in the false portion and make a second test for logic....so something like...
=if(E1=1,"e1=1",if(E1=2,"E1=2","E1 is not 1 or 2"))
This would be a formula in a cell, not a VBA macro.
Think it through based on the example.
