Had a hard time figuring out the following "If Then" fomula - so here are the
requirements and the solution to save some people some time

risk = version delta + microcode delta + (1 if monitoring = No) + (1 if %
throughput 80%) + (1 if % throughput 90%) + (1 if % throughput 95%) +
(1 if recovery time 5 minutes) + (1 if recovery time 10 minutes) + (1 if
recovery time 15 minutes) + (2 if recovery time 20 minutes)


=M4+P4+(IF(Q4="No",1,0))+(IF(U40.95,3,IF(U40.9,2 ,IF(U40.8,1,0))))+(IF(W420,4,IF(W415,3,IF(W410 ,2,IF(W45,1,0)))))


"Tomas" wrote:

How would I do the following:
A+B = C,
if C = 10 then D = 1
if C = 11 then D = 2
C = 12 then D = 3
and so on
C = 19 then D = 1
thank you!
__________________________________________________ _______________