Solved

One more of these

Posted on 2014-04-12
3
187 Views
Last Modified: 2014-04-12
I don't know why I have so much trouble with these; can somebody help?

I need it "with" and "without" the evaluate:

"= evaluate(if(py!0" & i6 & "<constants!$T$4 & ", 1, 0)")
0
Comment
Question by:BostonBob
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39996756
What is the formula?
0
 

Author Comment

by:BostonBob
ID: 39996829
for Row 10 it would look like:

=evaluate(if(py10<Constants$T$4, 1, 0)

for Row 10 it would look like:

=evaluate(if(py11<Constants$T$4, 1, 0)

and so on....

i6 can equal i for simplicity.

thanks,
0
 
LVL 27

Accepted Solution

by:
MacroShadow earned 500 total points
ID: 39996936
Evaluate and Constants are not Excel functions.

"=evaluate(if(py10<Constants$T$4, 1, 0)"
"=evaluate(if(py11<Constants$T$4, 1, 0)"
"=evaluate(if(py10" & i & "<constants!$T$4, 1, 0)" 

Open in new window

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is about my first experience with programming Arduino.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question