mikeeakins
New Member
- Joined
- Mar 29, 2023
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
ok so,Hi & welcome to MrExcel.
You haven't actually said what is wrong, but you need to lock the reference cell like
Excel Formula:=(M9+N9)>$E9*(1+0.6)
I think thats close .Ok, how about, for green
Excel Formula:=SUM($M9:N9)<$E9*1.6
This formula will be in every rowI think thats close .
It worked when the inventor was 3309 (e9), and green was to (O9 4/1) which added to 2960 so it was correct the rest of the way.
When I changed the inventory to 4000 it was green to (T9 4/6) but that total was 7110 and it should have been yellow at (Q9 4/3) with that total was 4260.
View attachment 88653