View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vdmbqb vdmbqb is offline
external usenet poster
 
Posts: 36
Default I need a formula

I have a formula in A2 that generates a number from other cells. I need a
formula in B2 that answers this requirement;

If A2 is greater than zero return 28, if A2=zero return zero.

Thank you in advance for this help.
--
bob