Silvermini63
Active Member
- Joined
- Sep 25, 2006
- Messages
- 293
Um I know this isn’t quite right but what I am trying to do is put a fail safe in
Basically if the last bit is what I am having trouble with if f4 is greater than L4 (can’t remember which way the sign is to go) put in L4’s value minus 1 cent. That after all of the if at the beginning is looked at
Please help….
=IF(ISBLANK(B4),"",IF(G4=0,D4/(100%-$I$2),D4/(100%-G4),IF(f4>L4,L4-.01,f4))))
Basically if the last bit is what I am having trouble with if f4 is greater than L4 (can’t remember which way the sign is to go) put in L4’s value minus 1 cent. That after all of the if at the beginning is looked at
Please help….
=IF(ISBLANK(B4),"",IF(G4=0,D4/(100%-$I$2),D4/(100%-G4),IF(f4>L4,L4-.01,f4))))