Logical formula

[harignz]

Hi there

I would like to put a logical formula to identify customer status by Category

Say Colum “D” = Budget & Colum “E” = Actual Sales

Budget Result Actual Sales Result Category

Budget Value > Actual Sales 85% of Budget "Active"
Budget Value = 0 Actual Sales >1 "New"
Budget Value > Actual Sales 70% of Budget "Attack"
Budget Value > Actual Sales < 20% of Budget "LOST"

Appreciate for your help in advance.

[jraj1106]

Hi...

Can u provide more specific data?

[DGagnon]

can you attach a sample? and as an example for your first senario are you looking for Budget value > Active Sales, and Active sales = 85% of budget?

[vlady]

like this.

Please Login or Register  to view this content.

one question is that equal >1 ?
and the other one equals also?

sorry those are D not B

[harignz]

Logical Formula Sample.xlsx

First time I'm using Thread, so not sure does it attched or not.

[vlady]

Please Login or Register  to view this content.

[Celesty]

Please Login or Register  to view this content.

It is giving error, I am not sure what needs to change. I have applied it as below but it is not taking '-' for '-' or NEW. it shows either only active & lost for all
=IF(AND(D4>E4,E4<(D4*20%)),"LOST",IF(AND(D4>E4,E4=(D4*70%)),"ATTACK",IF(AND(D4=0,E4>1),"NEW",(IF(D4>E4,E4=(D4*85%),"ACTIVE")))))