A Simple Formula in Excel 1

[RayMunro]

I know this probably has a simple answer but I would be grateful for the help.

I need a cell to show a value of 1 or 0 depending on whether there is data in another cell in the same row or not.

Thank you

 

[Scott24x7]

Yup, its an easy one.

In the cell you want a 1 or 0 enther:

=IF(ISBLANK(<cell with value>),0,1)

Where 0 says "Yes I'm empty"
and 1 says "No, I've got data"

just reverse them if you want them the other way around.


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[GlennUK]

Just for interest, logical functions such as ISBLANK return TRUE or FALSE, which can be translated into their numeric equivalents of 1 or 0 quite easily by multiplying by -1 twice, like this:

=--ISBLANK(<cell with value>)

( the "--" does the multiplying by -1 twice )

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.