IF/AND/OR Formula?
Would anyone know how to craft a formula that caputures the following three
scenarios in one cell?
10 Units purchased
$1.168 RANGE @ 95% - 105%
A: Today's rate B: Today's rate C: Today's rate
2.17 1.05 1.19
IF/AND/OR formula that compare's todays rate to range of prices between
95%-105% of $1.168 above:
A) if today's rate is than 105% of $1.168, then pick 105% * 1.168 * 10
units
B) or if today's rate is < than 95% of $1.168, then pick 95% * 1.168 * 10
units
C) or if today's rate is within the range of 95% to 105% of $1.168, then
pick Today's rate 1.19 * 10 units.
|