MS Excel / VBA help thread

You are reading a single comment by @chez_jay and its replies. Click here to read the full conversation.

•

Light_EDDed

So using the example the annual spend should be £1000.

Within 25% of £1000
Within 50% of £1000
Within 75% of £1000

Based on current spending. So I have a revised weekly value column to show the weekly spend and *52 to give me a projected 52 week spend.

•

chez_jay in reply to @Light_EDDed

the annual spend should be £1000.

For every company?

I think you're going to need to share actual (fake data) sheet to show where you've got to.

Edit: also, your worked example gives 4 outcomes, not the three you'd expect (red/amber/green)

About

Avatar for chez_jay @chez_jay started