IF/AND/OR Formula?

[sqd05]

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.

[[email protected]]

"sqd05" wrote:
> Would anyone know how to craft a formula that caputures
> the following three scenarios in one cell?
> [....]
> A: Today's rate B: Today's rate C: Today's rate
> 2.17 1.05 1.19
> [....]
> 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.

For column A (copy across for columns B and C):

=10 * if(A1 > 105%*1.168, 105%*1.168,
if(A1 < 95%*1.168, 95%*1.168, A1))