0

Formula Help Needed

What is wrong with this formula? I want the result to be 2.85 when between 50 and 100, and 0 for all else. The result I get is 2.85 all the time.

Screen Shot 2020-06-29 at 4.53.11 PM

2 replies

null
    • Cegep de jonquiere
    • James_Deraps.1
    • 4 yrs ago
    • Reported - view

    If 'Ask Price' > 50 and 'Ask Price <100 then ...

    • Mr_K
    • 4 yrs ago
    • Reported - view

    Sweet. Got it working now. Thanks James.

Login to reply

Content aside

Categories

View all topics
  • 4 yrs agoLast active
  • 2Replies
  • 478Views