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