Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a less than or equal to formula in exel??
I would like to set up an if statement that utilizes the less than or equal
to concept. How do I do that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a less than or equal to formula in exel??
"hana72" wrote:
I would like to set up an if statement that utilizes the less than or equal to concept. How do I do that? "less than or equal to" is denoted using: <= A simple example In B1: =IF(A1<=0,"",A1) -- Max Singapore http://savefile.com/projects/236895 Downloads:22,000 Files:370 Subscribers:66 xdemechanik --- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a less than or equal to formula in exel??
=IF(B1<=A1,"yes","no") entered in C1
But I'm sure there is more to this than what you have asked. Post back if more details are to be given. Gord Dibben MS Excel MVP On Thu, 8 Jan 2009 16:11:35 -0800, hana72 wrote: I would like to set up an if statement that utilizes the less than or equal to concept. How do I do that? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a less than or equal to formula in exel??
Hi
To use less than or equal to formula in excel you should combine it with AND logical function. "hana72" wrote: I would like to set up an if statement that utilizes the less than or equal to concept. How do I do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I create a fifo formula in exel | Excel Worksheet Functions | |||
how to change formula into value exel cells | Excel Worksheet Functions | |||
Exel formula | Excel Discussion (Misc queries) | |||
how do I convert a non exel tabulation to exel | New Users to Excel | |||
Why i have my exel formula like this =L[-310]C+L[-256]C+L[-2]C | Excel Discussion (Misc queries) |