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"))
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 ...
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...
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"))
This is shorter formula but with the same result
=IF(A1>0,"z","x")
I am trying for your exact requirment
Here is your exact solution
=IF(F1="","x",IF(F1=0,"y",IF(F1>0,"z","")))
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.
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
thanks a lot it worked.
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.
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
Like this thread? Share it with others