Having trouble with a "If, Then" calculation in a form field, Please Help!
I have the "If Then" statement working in it's simplest form but I
think i have the formatting on the calculation wrong. This is what I
have so far:
{=if (A1B1,(A1-B1)-((A1-B2)*C1)+B1,A1}
OR
=IF (3000900,(3000-900)-((3000-900)*.70)+900,3000)
Can anyone tell me what it is I am doing wrong?
|