From: Moz on 26 Mar 2010 11:02 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.
From: Luke M on 26 Mar 2010 12:41 =IF(A2<B2,"Less than",IF(A2>B2,"More than","")) -- Best Regards, Luke M "Moz" <Moz(a)discussions.microsoft.com> wrote in message news:EAAE3174-4B05-4742-BCED-48759963B71E(a)microsoft.com... >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.
|
Pages: 1 Prev: Problem with Typing "&" in Excel Header section Next: Link a textbox on a sheet to a cell?! |