Posted 27 Days Ago Job ID: 1618387 40 quotes received

Excel Formula Writer

Fixed Price or Hourly
Quotes (40)  ·  Premium Quotes (0)  ·  Invited (0)  ·  Hired (1)

  Send before: January 09, 2020

Send a Quote

Programming & Development Math / Algorithms / Analytics

I need the following formula written for excel.

I want column b to = 1 when column A is < .52501 and column B will now stay at 1 until one of the following happens: 

if A > .70, then column B should now = 0 until column A < .5201 again. or

 Column A increases above .60 and then falls back down be ... Show more
Jon A N United States