Page 1 of 3 123 LastLast
Results 1 to 10 of 26

if cell blank do "x", if cell zero do "y", if cell > zero do

This is a discussion on if cell blank do "x", if cell zero do "y", if cell > zero do within the Excel Questions forums, part of the Question Forums category; please, i'm new to excel scripting... how do a write a condition that can check a currency column (has to ...

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    9

    Default

    please, i'm new to excel scripting...

    how do a write a condition that can check a currency column (has to be a number) that can know if the column has anything in it?

    if the cell has no input i want to do "x",
    if the cell has a zero i want to do "y",
    if the cell has a number greater than one i want "z"

    thanks...

  2. #2
    New Member
    Join Date
    Aug 2002
    Posts
    32

    Default

    All i can give you answer is that if cell is blank or cell have the number "0" you get the same responce all i can give you help is for is the cell is blank/zero or greater than zero

    =IF(A1="","x",IF(A1>0,"z"))




  3. #3
    New Member
    Join Date
    Aug 2002
    Posts
    32

    Default

    This is shorter formula but with the same result

    =IF(A1>0,"z","x")

    I am trying for your exact requirment

  4. #4
    New Member
    Join Date
    Aug 2002
    Posts
    32

    Default

    Here is your exact solution

    =IF(F1="","x",IF(F1=0,"y",IF(F1>0,"z","")))





  5. #5
    New Member
    Join Date
    Sep 2009
    Posts
    2

    Default Re: if cell blank do "x", if cell zero do "y", if cell > zero do

    Hi i am trying to do some calculation but needing a bit help

    my problem is

    B20 C20 F20 H20 I20 DIFFERENCE C20-I20
    1 0.00 0.00 0.00 0.00 0.0


    What i want is if the value 0 in C20 the value will be 0 in H20 but same time i must be able to enter different values in C20 and H20 as well .. so it will work when its only entered 0 otherwise will work normal . or it can be if i enter anything in C20 than H20 will be default 12.49 if not will be 0

    if you can give me for both i will be greatful
    thank you so much.

  6. #6
    New Member
    Join Date
    Jan 2011
    Posts
    3

    Default Re: if cell blank do "x", if cell zero do "y", if cell > zero do

    Can anyone provide me formula for below request?

    IF A1>=4 & A2>=4 on Cell A5 text has to be displayed as "V.Good"
    IF A1>=3 & A2>=4 on Cell A5 text has to be displayed as "Good"
    IF A1>=3 & A2>=3 on Cell A5 text has to be displayed as "OK"

    IF A1>=3 & A2>=4 & A3="Others" on Cell A5 text has to be displayed as "Out Standing"

    ~rgds,
    Kris

  7. #7
    Board Regular
    Join Date
    Feb 2009
    Location
    Anchorage, AK, USA
    Posts
    317

    Default Re: if cell blank do "x", if cell zero do "y", if cell > zero do

    Quote Originally Posted by kkrishna View Post
    Can anyone provide me formula for below request?

    IF A1>=4 & A2>=4 on Cell A5 text has to be displayed as "V.Good"
    IF A1>=3 & A2>=4 on Cell A5 text has to be displayed as "Good"
    IF A1>=3 & A2>=3 on Cell A5 text has to be displayed as "OK"

    IF A1>=3 & A2>=4 & A3="Others" on Cell A5 text has to be displayed as "Out Standing"

    ~rgds,
    Kris
    =if(and(A1>=3,A2>=4,A3="Others"),"Outstanding", if(AND(A1>=4,A2>=4),"V.Good", if(and(a1>=3,A2>=4),"Good","")))

    It's usually best when doing nested IF statements that you put the arguments in cascading order.

  8. #8
    New Member
    Join Date
    Jan 2011
    Posts
    3

    Default Re: if cell blank do "x", if cell zero do "y", if cell > zero do

    thanks a lot it worked.

  9. #9
    New Member
    Join Date
    Jun 2011
    Posts
    1

    Question excel project

    qty item per price net price
    2 a 7 14
    1 b 9 9
    2 c 4 8


    in above table i want to insert or type
    only the number of quantity and item name.

    For example i enter "qty=2" "item=c"
    in this situation i want the "per price" automatically how can i do this plz anybody help.

  10. #10
    New Member
    Join Date
    Jul 2011
    Posts
    2

    Exclamation Re: if cell blank do "x", if cell zero do "y", if cell > zero do

    hey everyone, i neeeeeeeeeed help from you guys, i want to make a formula that puts no.1 in case the cell i2 is greater than 5 and when it is blank,to either put 0 or to put nothing at all,thats the formula i have =+IF(I2>5,1," ") However, it keeps putting no. 1 even when the cell is blank

Page 1 of 3 123 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com