question 2: how much will it cost to repair your house? $Y
question 3: what are you asking for your house? $Z
I need a rule that will calculate the following: q1 X 75%, - q2 = Max Offer. Rule: If q3 is greater than Max offer then go to q4, if question 3 is equal to or less than Max offer then go to q5.
Best answer by john.desborough
@vince lopez02 - try this out --- create variables called v_max, v_q3_calc first
q1:
if q1 is greater than 0 then add q1 to v_max
if q1 is greater than 0 then multiply v_max by .75 (you might have to do this in two steps - multiply by 75 then divide by 100)
q2:
if q2 is greater than or equal to 0 subtract q2 from v_max
q3
if q3 is greater than 0 add q3 to v_q3_calc
if q3 is greater than 0 subtract v_max from v_q3_calc
