Thread: I want to compare totals and flag those less than or more than
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
  
Posts: 457
Default I want to compare totals and flag those less than or more than
=IF(A2<B2,"Less than",IF(A2B2,"More than",""))

--
Best Regards,

Luke M
"Moz" wrote in message
...
I would like to find a formula to compare number in one column to the next
column and flag them as less than or more than the base number.


Reply With QuoteReply With Quote