| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel spred shet
how do i enter formula if b25 is less/grater then 5% of e25
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automaticall pick up info from a cell from a shet t oanither sheet , in the same cell, same book | Excel Worksheet Functions | |||
| Protected work shet | Excel Discussion (Misc queries) | |||
| how do I creat a diary spred sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
