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?

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
---

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?

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?