Formula for providing value if value is shown in other cell

[Stromming]

Hi guys,

Need your help with this one.

I need a formula where a value will be provided based on the value of another cell

A1 A2

B1 B2


Say A1 is empty but A2 contains date 01 Aug
If this is correct I want (with 1 formula) to have B1 as 0 and B2 as 17

However the trick is that we cannot assume that there is anything in either cells. I have a date formula that will give me dates in different places depending on week/month so the formula needs to simply see that there is a date in there.

Basically = if value is shown, give me 17, if no value is shown, give me 0.

Hope you guys can help me on this

[Olly]

In B1, enter:

=if(A1="",0,17)

Copy to B2.

[Crooza]

In B1

=if(a1="","",17)

and copy across to b2 as well

[Crooza]

I love it when we write the same thing and hit the 'send' button at the same time

[Stromming]

Thanks guys,

I have to admit that this was a bit embarassing as its such a simple thing and I've looked at this formula earlier today in another report...