View Single Post
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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