bluepenink
Well-known Member
- Joined
- Dec 21, 2010
- Messages
- 585
Hello
Having some problem disecting an if statement, below is my issue
Column N contains text = 3-5 days
Column J contains value = i.e. 8
3-5 days is budgeted, and 8 days is the actual
so i need an if statement to say,
-if column J > 3-5 days, then Yes, No
Similarly, i then need to calculate how many days its over by
so i.e. if the budgeted says "3-5 days" and actual was 8, therefore, 8-5 = 3
so how can i make the if statement in part two say that?
can someone pls help. thx you!
Having some problem disecting an if statement, below is my issue
Column N contains text = 3-5 days
Column J contains value = i.e. 8
3-5 days is budgeted, and 8 days is the actual
so i need an if statement to say,
-if column J > 3-5 days, then Yes, No
Similarly, i then need to calculate how many days its over by
so i.e. if the budgeted says "3-5 days" and actual was 8, therefore, 8-5 = 3
so how can i make the if statement in part two say that?
can someone pls help. thx you!