Thread: if then statement... can't make it work:S
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
sed sed is offline
external usenet poster
  
Posts: 24
Default if then statement... can't make it work:S
Thanks again John!
--
sss


"John C" wrote:

=IF(ABS(A1)<5.01,1,0)
or
=ABS(A1)<5.01

Hope this helps.
--
John C


"sed" wrote:

i need some help trying to write a formula that states the following:
if a1 is greater than -5.01 and less than 5.01 then 1, 0
Thank you

Reply With QuoteReply With Quote