View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default I need a formula

=IF(A2=0,0,28)

If my comments have helped please hit Yes.

Thanks.

"vdmbqb" wrote:

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