Hello People,

This is my first post on ExcelForum.com - apologies for not posting an introduction and diving straight into the issue I'm having with my Excel Formula.

Basically, I have a tape storage record which I record all backup tape information. I have added an additional column called Action which tells me what I need to do with the tapes when I update their information.

Here's the table:
15RpSMI.png

Current formula: "=IF(AND(F2=$K$3,G2=$L$2),"Remove, label & move to Leeds safe","No action required")"

What I want it to do !
Backup tapes have to be removed from the Tape Library and put into the on-site safe. The tapes must then be moved to the Leeds safe - but my formula states "no action required". I need to fix that.

Currently I'm using two Logical Tests:

If F2 (physical location) = $k$3 ( Tape Library)
If G2 (capacity) = $L$2 (Full)
Value if true: "Remove, label & move to Leeds safe"
Value if false: "No action required"

Ideally it needs to do this - which I haven't been able to do:

If F = Leeds Safe (Action: "No action required") because that's where the tape needs to be - in off-site storage)
If F = Tape Library & G2 = Full (Action: "Remove, Label and move to on-site safe") - This tape would need to be removed from the tape library device

If F = on-site Safe (Action: Move to Leeds Safe)


Hope somebody can point me in the right direction - thank you