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
 Pdf and xps add in 2010  Download  Other
 Microsoft publisher 2010 free download  Download  Publishing
 Number to words in excel formula  Guide
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.