Using the "less than or equal to" symbol in a spreadsheet

Discussion in 'New Member Introductions - Site Assistance' started by fireant222, Dec 31, 2012.

  1. fireant222
    Offline

    fireant222 iPF Noob

    Joined:
    Dec 31, 2012
    Messages:
    4
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    I am trying to create a spreadsheet in Numbers. One of the equations calls for the "less than or equal to..." symbol.

    Every time I try to enter it I get the error button (exclamation point on red triangle".)

    Can someone help me by explaining how to format is cell to receive this symbol?

    Thanks,
    Kenneth
  2. AQ_OC
    Offline

    AQ_OC Super Moderator Staff Member

    Joined:
    Apr 28, 2011
    Messages:
    6,418
    Thanks Received:
    430
    Trophy Points:
    83
    Location:
    SC
    Ratings:
    +430 / 0
    Is it not <= or =<?
  3. fireant222
    Offline

    fireant222 iPF Noob

    Joined:
    Dec 31, 2012
    Messages:
    4
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Yes, either. The spreadsheet will not accept it in the cell when I use the Numbers app. It just gives me an error message.

    For example, if I were to type "<= 30" into a cell under a column heading called "Limits" I would get an error message, usually prefacing a syntax error.

    I would get the same syntax error if I were to use the correct symbol as well.
    Last edited: Dec 31, 2012
  4. AQ_OC
    Offline

    AQ_OC Super Moderator Staff Member

    Joined:
    Apr 28, 2011
    Messages:
    6,418
    Thanks Received:
    430
    Trophy Points:
    83
    Location:
    SC
    Ratings:
    +430 / 0
    Sometimes, the error is in another part of the logic statement. Did you check that too?
  5. fireant222
    Offline

    fireant222 iPF Noob

    Joined:
    Dec 31, 2012
    Messages:
    4
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    The spreadsheet calls for 3 columns, an X column with a quantity in it, a Y column with a quantity in it, and a limits column with a quantity limit in it.

    Are you saying that I may have to type the entire equation in the cell to get it to accept the symbol? Example, 5x -4y <= 30

    ?
  6. AQ_OC
    Offline

    AQ_OC Super Moderator Staff Member

    Joined:
    Apr 28, 2011
    Messages:
    6,418
    Thanks Received:
    430
    Trophy Points:
    83
    Location:
    SC
    Ratings:
    +430 / 0
    I'm saying that the logic statement has to be correctly give ... like if(x<=y,true,false). That kind of thing. If the logic is true, what happens, and if it is false, what then. At least that's my experience ...
  7. fireant222
    Offline

    fireant222 iPF Noob

    Joined:
    Dec 31, 2012
    Messages:
    4
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Yea. You're right. I guess I thought there was an option to simply type it in as separate characters.

    Thanks. I guess I should have just done that from the beginning.

    Ken
  8. zstairlessone
    Offline

    zstairlessone iPad Ninja

    Joined:
    Jun 22, 2012
    Messages:
    2,052
    Thanks Received:
    439
    Trophy Points:
    83
    Location:
    California
    Ratings:
    +439 / 0
    I haven't used numbers but you might try an if statement

    =IF(A1+B1 <=30,whatever you want if less than or equal to,what you want if greater than)

    For instance, if you want to see the answer if it is less than or equal to 30 and a blank if greater than it would look something like this ill use sum instead of adding here

    =IF(SUM(A1,B1) <= 30,SUM(A1,B1),"")

Share This Page

Search tags for this page
greater than or equal to on ipad
,

greater than or equal to symbol ipad

,
hot to write greater than or equal to in mac numbers
,
how do you make greater than or equal to sign on ipad
,
how to do greater than or equal to symbol ipad
,
how to get a greater than or equal sign in iphone
,
how to insert the equal or greater than sign on ipad
,

how to make equal sign on ipad

,

how to make the sign less than on the ipad

,

how to type a less than or equal to sign on an ipad

,
how to type equal sign on ipad
,
in a logic statement, is -5 less than -3
,
less than or equal to numbers spreadsheet
,
less than or equal to on the ipad
,

less than or equal to sign on ipad

,
less than or equal to symbol on ipad
,
less than or equals sign in ipad pages
,
mac os numbers type greater than or equal to
,
on ipad how to get to equal sign
,
what ipad apps greater than or equal to symbol