I have a list of possible exposure values, which I need to compare with the calculated value, and choose the closest one.
This is quite tedious as there are 20 values or so to compare with . Does someone see a better way of doing this ?Code:// This finds closest match If 0<exposure<0.00025 Then Output "Closest exposure value is 1/4000" Else If 0.00025<exposure<0.0005 Then Output "Closest exposure value is 1/2000" Else If 0.0005<exposure<0.001 Then Output ""Closest exposure value is 1/1000" ...