Help urgent - excel formula !!

[azamsiddiq]

Hello,
I need help with the following formula and i would really appreciate if anyone can help ASAP. I have columns from A through AF and this is the formula i want to have :
"IF column T is blank, column U through AE should be blank, If column T says AMF, column K through S should be blank"

 

[Nalani]

Welcome to the Board

I got here As Soon As Possible being that your thread was Urgent

Couple questions:
1. What Cell is this formula needed in
2. What if Column T has something other then blank or AMF, then what happens
3. Have you looked at the IF and the OR functions in Help
4. And most of all have you looked here:
http://www.mrexcel.com/forum/showthread.php?t=127080

for guidance on your question?

Note;
I'm not a Moderator, but answers to the above will help all to see what exactly you need.

 

[azamsiddiq]

thanks for replying , The formula needs to be in column S, I am using IF OR functions but i can't formulate the formula. thats what i have created but doenst seem to be working:

=IF(T6="",IF(OR(T6="nmi",K6:S6="",),U6:AE6=""))

 

[dave3009]

Hello,
I need help with the following formula and i would really appreciate if anyone can help ASAP. I have columns from A through AF and this is the formula i want to have :
"IF column T is blank, column U through AE should be blank, If column T says AMF, column K through S should be blank"

Welcome to the board. Small peice of advice for future, everyone here volunteers their time, there is no Urgent or ASAP. See point 12 here

So you need to rewrite the formulas in column U through AE so that they read

=IF($T2="", "", Actual Cell Function)

And K to S similarly

=IF($T2="AMF", "", Actual Cell Function)

 

[Nanette]

Hi azamsiddiq

enter this formula into your required cell and copy down. You will need to change the '7' to be your line no

=IF(T7="",IF(sum(U7:AE7)=0,"","fail"),IF(T7="AMF",IF(sum(K7:S7)=0,"","fail"),""))

Nanette

 

[azamsiddiq]

Thanks Nanette but the columns ( U through AE) and ( column K through S ) cant be summed as there is text and numbers in the columns

 

[Nanette]

a bit fiddly, but is working for me
=IF(T7="",IF(OR(U7>0,V7>0,W7>0,X7>0,Y7>0,Z7>0,AA7>0,AB7>0,AC7>0,AD7>0,AE7>0),"fail",""),
IF(T7="AMF",IF(OR(K7>0,L7>0,M7>0,N7>0,O7>0,P7>0,Q7>0,R7>0,S7>0),"fail",""),""))

replace 7 with your row no,

 

[dave3009]

OR(U7>0,V7>0,W7>0,X7>0,Y7>0,Z7>0,AA7>0,AB7>0,AC7>0,AD7>0,AE7>0)
OR(K7>0,L7>0,M7>0,N7>0,O7>0,P7>0,Q7>0,R7>0,S7>0)

The OR functions could be shortened to

=MAX(U7:AE7)>0
=MAX(K7:S7)>0

respectively

 

[Nanette]

Thnx Dave - I was sure there'd be a simpler, concise version, I'll be able to use that!

Regards
Nanette