ExcelBanter - I want to compare totals and flag those less than or more than

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I want to compare totals and flag those less than or more than (https://www.excelbanter.com/excel-discussion-misc-queries/259981-i-want-compare-totals-flag-those-less-than-more-than.html)

Moz

I want to compare totals and flag those less than or more than

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.

Luke M[_4_]

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.

All times are GMT +1. The time now is 02:05 PM.