J
Jake
I’m working on a pricing spreadsheet that calculates the price based on the
amount of exposure that we are subjected to. I have the pricing scale that
assigns a pricing factor to the exposure. Here is a small, hypothetical
sample:
Exposure % Factor
10% 0.9
20% 0.8
30% 0.7
40% 0.6
50% 0.5
The actual list has nearly 200 different exposure % and factors.
I can easily calculate the exposure % in excel, but I want to find a way to
make that exposure % reference the corresponding factor automatically in
another cell. Any suggestions?
amount of exposure that we are subjected to. I have the pricing scale that
assigns a pricing factor to the exposure. Here is a small, hypothetical
sample:
Exposure % Factor
10% 0.9
20% 0.8
30% 0.7
40% 0.6
50% 0.5
The actual list has nearly 200 different exposure % and factors.
I can easily calculate the exposure % in excel, but I want to find a way to
make that exposure % reference the corresponding factor automatically in
another cell. Any suggestions?