beardedcraig
New Member
- Joined
- Aug 2, 2018
- Messages
- 3
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Allocated Budget[/TD]
[TD="align: center"] Spend[/TD]
[TD="align: center"]Forecast Spend[/TD]
[TD="align: center"]Total Spend (inc. Forecast)[/TD]
[TD="align: center"]Max Budget (Overspend)[/TD]
[TD="align: center"]Budget RAG[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]£100[/TD]
[TD="align: center"]£50[/TD]
[TD="align: center"]£25[/TD]
[TD="align: center"]£75[/TD]
[TD="align: center"]£110[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Can anyone help correct my formula please? I basically want to work out a single formula to use in F2 for the following rules:
IF D2<=A2 then display "G", IF D2>A2 and D2<e2 then="" display="" "a"="" or="" if="" d2="">E2 then display "R" ELSE display " "
The closest I have gotten is:
=IF((D2<=A2, "G", IF(AND(D2>A2, D2<e2), "a",="" if(d2="">E2, "R"), ""))</e2),></e2>
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Allocated Budget[/TD]
[TD="align: center"] Spend[/TD]
[TD="align: center"]Forecast Spend[/TD]
[TD="align: center"]Total Spend (inc. Forecast)[/TD]
[TD="align: center"]Max Budget (Overspend)[/TD]
[TD="align: center"]Budget RAG[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]£100[/TD]
[TD="align: center"]£50[/TD]
[TD="align: center"]£25[/TD]
[TD="align: center"]£75[/TD]
[TD="align: center"]£110[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Can anyone help correct my formula please? I basically want to work out a single formula to use in F2 for the following rules:
IF D2<=A2 then display "G", IF D2>A2 and D2<e2 then="" display="" "a"="" or="" if="" d2="">E2 then display "R" ELSE display " "
The closest I have gotten is:
=IF((D2<=A2, "G", IF(AND(D2>A2, D2<e2), "a",="" if(d2="">E2, "R"), ""))</e2),></e2>