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

liquidrobot

New Member
Joined
May 13, 2002
Messages
9
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...
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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
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
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
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

=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
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
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 :confused:
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,237
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top