# 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. 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. 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. This is shorter formula but with the same result

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

I am trying for your exact requirment

4. Here is your exact solution

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

5. ## 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. ## 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. ## Re: if cell blank do "x", if cell zero do "y", if cell > zero do

Originally Posted by kkrishna
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. ## Re: if cell blank do "x", if cell zero do "y", if cell > zero do

thanks a lot it worked.

9. ## 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. ## 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 Last

#### Posting Permissions

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