Help Excel & nesting functions

[Rubric]

Ok i have tried to make this work but i just can't. I'm hoping one of you lovely peoiple can help me out.

I need to know how to write a formula in excel which basically does the following.

the formula will be in cell c1 and basically i want
if b1 is blank then leave blank, if b1 = a1 display unallocated and if b1 does not equal a1 display allocated.

Please please please can someone tell me how to do this.


Yours in anticipation.

 

[djpringle]

ok in open office it is...

=IF(ISBLANK(B1);" ";IF(A1=B1;"unallocated";"allocated"))

It should be very very similar in Excel (ISBLANK checks the (cell) for contents in openoffice but not sure what the Excel function is) but the ; are replaced with , I think...

Part of the reason why I hate working with both...

 

[dysfunction]

It is the same in regular excel

=IF(ISBLANK(B1),"",IF(B1=A1,"Unallocated",Allocated))

 

[Rubric]

Fantastic, i will give that a shot on monday.

I could do one or the other but not both as i didn't know how to write it together.

Thanks guys one automated report from Monday