N
Natalie
Hello,
I have 2 tables, 1 with amount of credit due (bottom table) and I want to be
able to enter the number of minutes in downtime (top table) and return the
right amount of credit due back in the adjacent field.. Should be a nested if
but I can't get it to work..
Period Downtime in Mins
Jan 10
Feb 0
Mar 0
Apr 0
May 0
Jun 0
Jul 0
Aug 0
Sep 0
Oct 0
Nov 0
Dec 0
Outage times in mins % SC Due MRR Credit due
0-43 0% £23,536.99 £0.00
44-216 20% £23,536.99 £4,707.40
217-432 35% £23,536.99 £8,237.95
433-4320 50% £23,536.99 £11,768.50
4320+ 75% £23,536.99 £17,652.74
I have 2 tables, 1 with amount of credit due (bottom table) and I want to be
able to enter the number of minutes in downtime (top table) and return the
right amount of credit due back in the adjacent field.. Should be a nested if
but I can't get it to work..
Period Downtime in Mins
Jan 10
Feb 0
Mar 0
Apr 0
May 0
Jun 0
Jul 0
Aug 0
Sep 0
Oct 0
Nov 0
Dec 0
Outage times in mins % SC Due MRR Credit due
0-43 0% £23,536.99 £0.00
44-216 20% £23,536.99 £4,707.40
217-432 35% £23,536.99 £8,237.95
433-4320 50% £23,536.99 £11,768.50
4320+ 75% £23,536.99 £17,652.74