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")"
<tbody>
</tbody>
Hope somebody can point me in the right direction - thank you
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")"
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) |
<tbody>
</tbody>
Hope somebody can point me in the right direction - thank you