Hi Karin
=IF(logical_test,value_if_true,value_if_false)
If A25 = x then do this 1/$A$50 (1 divide thru a50)
If not display a 0
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Karen" wrote in message ...
Would someone please explain the following formula in lamen's terms?
Specifically, what does the "1" and "0" mean?
=IF(A25-"x",1/$A$50,0)
Thank you