Hi,

Try this =if(and(b8<=0.8501,b80.80),C3*0.0063/12,C3*0.0086/12,0)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"lena" wrote in message
...
I need a formula to: If 'B8' 80% then 'C3' * .63% and / that by 12, if
'B8'
is 85.01%, * 'C3' by .86% and / that by 12, etc. Please help with
example.
--
lena