Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • its impossible to write out the entire formula but i will do enough to get you started…ok lets assume the following price list …
    house reg. moving, 1 level, 1 bdrm, 1 bathroom is $70
    unit, moving out, number of bdrms, and 1 bathroom is $165

    then the formula would look like this…
    if(and(house = “yes”,reg_moving = “yes”, level*bdrm*bathroom,if(and(unit = “yes”,moving out = “yes”,unit*level*bdrms*bathrooms),””)))

    the above statement says if house and reg_moving is equal to yes then multiply level by bdrooms by bathrooms, if that is not the case go to the next if statement which says if unit and moving out are yes then multiply level by bedrooms by bathrooms. if both of these conditions are not met then give a false response denoted by “”.

    good luck i hope this can get you on your way

    if(elementid condition, true condition, false conditon)

    you would need to be a little more descriptive, maybe the real life use of the equation would help. what would you like the output to me.
    otherwise the simple solution is if(elementID = a, a*1, “”)
    where elementID is the condition, a*1 if the condition is true, do nothing “” if the condition is false.
    you can send me an email if you like further instructions.
    thanks!

Viewing 2 replies - 1 through 2 (of 2 total)