Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|