Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

One more of these

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
BostonBob
Asked:
BostonBob
  • 2
1 Solution
 
MacroShadowCommented:
What is the formula?
0
 
BostonBobAuthor Commented:
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
 
MacroShadowCommented:
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now