If(AND Multiple Logic issues - Backup Tape Spreadsheet

[squirrelz]

Hello People,

This is my first post on MrExcel.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:

Current formula: "=IF(AND(F2=$K$3,G2=$L$2),"Remove, label & move to Leeds safe","No action required")"
[TABLE="width: 577"]
<tbody>[TR]
[TD]What I want it to do ![/TD]
[/TR]
[TR]
[TD]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.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Currently I'm using two Logical Tests:[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]If F2 (physical location) = $k$3 ( Tape Library)[/TD]
[/TR]
[TR]
[TD]If G2 (capacity) = $L$2 (Full)[/TD]
[/TR]
[TR]
[TD]Value if true: "Remove, label & move to Leeds safe"[/TD]
[/TR]
[TR]
[TD]Value if false: "No action required"[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Ideally it needs to do this - which I haven't been able to do:[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]If F = Leeds Safe (Action: "No action required") because that's where the tape needs to be - in off-site storage)[/TD]
[/TR]
[TR]
[TD]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[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]If F = on-site Safe (Action: Move to Leeds Safe)[/TD]
[/TR]
</tbody>[/TABLE]


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

 

[RCBricker]

IF(G2="Full",IF(F2="On-Site Safe","Move to Leeds Safe",IF(F2="Tape Library","Remove,Label and move to on-site safe","No Action Required")))

Let me know if that works if not we will adjust.