How do I set up a less than or equal to formula in exel??

[hana72]

I would like to set up an if statement that utilizes the less than or equal
to concept. How do I do that?

 

[Max]

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

 

[Gord Dibben]

=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

 

[Deepali Joshi]

Hi

To use less than or equal to formula in excel you should combine it with AND
logical function.