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

C

cool_solanki

New Member

Joined

Aug 20, 2002

Messages

32

• Jan 15, 2003

• #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"))

 

Upvote 0

C

cool_solanki

New Member

Joined

Aug 20, 2002

Messages

32

• Jan 15, 2003

• #3

This is shorter formula but with the same result

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

I am trying for your exact requirment

 

Upvote 0

C

cool_solanki

New Member

Joined

Aug 20, 2002

Messages

32

• Jan 15, 2003

• #4

Here is your exact solution

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

 

Upvote 0

C

Cypriot

New Member

Joined

Sep 30, 2009

Messages

2

• Sep 30, 2009

• #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.

 

Upvote 0

K

kkrishna

New Member

Joined

Jan 12, 2011

Messages

16

• Jan 12, 2011

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

 

Upvote 0

S

sr12345

Active Member

Joined

Feb 20, 2009

Messages

317

• Jan 12, 2011

• #7

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

kkrishna said:

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

Click to expand...

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

 

Upvote 0

K

kkrishna

New Member

Joined

Jan 12, 2011

Messages

16

• Jan 17, 2011

• #8

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

thanks a lot it worked.

 

Upvote 0

W

walikhan40

New Member

Joined

Jun 1, 2011

Messages

1

• Jun 1, 2011

• #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.

 

Upvote 0

B

brightpanther

New Member

Joined

Jul 15, 2011

Messages

2

• Jul 15, 2011

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

 

Upvote 0