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.

IF/AND/OR Formula?
 

"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))