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

[liquidrobot]

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

 

[Aladin Akyurek]

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

3 4 5 3 - this numbers are written at the end of quarter. And 2,5 can be written e.g. 15th july (or other day of year), and now I need to find formula, that at the end of III quarter (or other quarter of year) is comparing 3 4 5 3 and 2,5, showing number which were written last. In above example it should return 5 (value at the end of 3 quarter) because it was write further than 2,5 (15 july).

Try to post a sample including the accompanying dates...

 

[five box]

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

Try to post a sample including the accompanying dates...

http://speedy.sh/WW4cP/Example.xls

 

[oldbrewer]

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

I am amazed that nobody has pointed out that new questions should be in a new thread....

 

[Aladin Akyurek]

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

http://speedy.sh/WW4cP/Example.xls

Try rather one of these methods Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste.

 

[five box]

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

Try rather one of these methods Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste.

Thanks for help.

 

[Aladin Akyurek]

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

Thanks for help.

Your file is not downloadable. And most people interested to help do not open files from the internet. Hence the mrexcel tip.