Formula with several conditions to apply

**DKAbi** · 12-07-2012, 03:59 PM

I have this formula that works fine, but now I'd like to add a condition. Unfortunately my suggestion doesn't work. Basically, a value should only be shown as long as there is no value in either cell R or S, so I'm assuming the formula below should be connected to an OR statement at the end, as all the other conditions below should continue to apply if cell R or S are empty:

=IF(AND($G1="HSR";$H1="RFS";SUBSTITUTE(LEFT(E1;SEARCH(" ";E1)-1);".";",")*1>=20;SUBSTITUTE(LEFT(E1;SEARCH(" ";E1)-1);".";",")*1<=30);IF($I1="Complex";WORKDAY($K1;30;holidays);IF($I1="Medium";WORKDAY($K1;18;holidays);WORKDAY($K1;8;holidays)));"")

**dredwolf** · 12-07-2012, 05:10 PM

I don't see any reference to cells R(??) or S(??) ??
Not sure exactly what it is you are looking for?

**DKAbi** · 12-07-2012, 05:12 PM

Ah, but there is no reference to cell R or S (yet). That's the part I need help with

**dredwolf** · 12-07-2012, 05:19 PM

Okay...does this apply to the main(first) if statement where you have the "" ?

**dredwolf** · 12-07-2012, 05:26 PM

Try this
replace the "" with

IF(AND(R1="";S1="");'yourformula/data';"")

If both R1 and S1 are empty, then your formula applies, otherwise, if either has a value, nothing shows up?

Hope this helps