Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jada Mohammad   on Oct 11 In MS Office Category.

  
Question Answered By: Viheke Fischer   on Oct 11

I found that writing my work flow  in English helps me figure out the
logical flow. For example,

If Cells(1, 1) <> "" And Cells(2, 1) <> "" Then
> > If Cells(4, 1) <> "" Then
> > Range("E2").Value = 10
> > ElseIf Range("E4").Value = 11 Then (How to apply this to 1st If
> Then?)
> > Range("E8").Value = 11
> > Else (How to apply this to 2nd If Then?)
> > Range("E2").Value = 9
> >

Check to see if cell (1,1) and cell (2,1) contain text
If so, check to see if cell (4,1) contains text
If so, cell E2 equals 10
If not, cell E4 equals 11
If not, cell E2 = 9
if Not, Cell E4 = 11

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Help With Logical Flow Or get search suggestion and latest updates.


Tagged: