More IF's

[Silvermini63]

I have this current formula but I need to add another if to it. I have a cell reference which is E4 this cell is our Tier Price and what I want to do is if the person wants a tier price in stead of a contract price the put a 0 in G4.

So this order goes if the code is blank report nothing if the code is there and G4 is 0 the return E4, if G4 is blank return $i$2 base % Calculation and if G4 has a % calculate that and finally if L4 is lower than the end calculation return .01 below.

$I$2 = Base % Mark Up
D4 = Cost
B4 = Product Code
G4 = Tier (1)
L4 = Tier Ref (2)

=IF(ISBLANK(B4),"",IF(IF(G4=0,D4/(100%-$I$2),D4/(100%-G4))>L4,L4-0.01,IF(G4=0,D4/(100%-$I$2),D4/(100%-G4))))

Hope this makes sense

 

[acw]

Hi

Not sure but perhaps

=IF(ISBLANK(B4),"",IF(AND(LEN(G4)>0,G4 = 0),E4,IF(LEN(G4)=0,D4/(100%-$I$2),IF(D4/(100%-G4)>L4,L4-0.01,D4/(100%-G4)))))

Tony

 

[Silvermini63]

yes it worked seems all good thank you evry much