I need help in setting up a formula based upon a value. What i need is, if
the value of a specific cell is between -49 - 29, i need an "OK" in another
cell.
So, if the value of (A3) is 12, then i want an "OK" to automatically come up
in (A4).
Is this do-able? I know you can do "IF" formulas, but I cant find one that
fits.
Also, is there a way to turn a formula off if theres no value within a cell.
For example, i have a column titled "Bid" , one titled "Actual Amount" and
one titled "Difference." before the actual amount comes in, i leave the
cells blank, but i already have the "bid" amount and the formula specified in
"Actual Amount". So, i get a VALUE!# error message in my "Actual Amount"
cell.
I hope this makes sense. lol