beardedcraig
New Member
- Joined
- Aug 2, 2018
- Messages
- 3
A | B | C | D | E | F | |
1 | Allocated Budget | Spend | Forecast Spend | Total Spend (inc. Forecast) | Max Budget (Overspend) | Budget RAG |
2 | £100 | £50 | £25 | £75 | £110 |
<tbody>
</tbody>
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>