Excel spred shet
 

how do i enter formula if b25 is less/grater then 5% of e25

Excel spred shet
 

Less than:
B25<E25*0.05

Greater than:
B25E25*0.05
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"utpal" wrote in message
...
how do i enter formula if b25 is less/grater then 5% of e25

Excel spred shet
 

Dear Friend
thank you for the help but how do i do that in singel cell ?

"Ragdyer" wrote:

Less than:
B25<E25*0.05

Greater than:
B25E25*0.05
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"utpal" wrote in message
...
how do i enter formula if b25 is less/grater then 5% of e25

Excel spred shet
 

If you want the condition to be that B25 is *not equal* to E25*0.05, then
use B25<E25*0.05
--
David Biddulph

"utpal" wrote in message
...
Dear Friend
thank you for the help but how do i do that in singel cell ?

"Ragdyer" wrote:

Less than:
B25<E25*0.05

Greater than:
B25E25*0.05
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"utpal" wrote in message
...
how do i enter formula if b25 is less/grater then 5% of e25