Need formula rectification..

[VBABEGINER]

Error - You formula is missing Parenthesis..What is this error..

=IF(AND(AN2="MR",INT(24*AO2)>8),"> 8 Hrs",IF(AND(AN2="MR",INT(24*AO2)<8),"< 8 Hrs"),IF(AND(AN2="MRR",INT(24*AO2)>1.5),"> 1.5 Hrs",IF(AND(AN2="MRR",INT(24*AO2)<1.5),"< 1.5 Hrs",IF(AND(AN2="RR",INT(24*AO2)>24),"> 24 Hrs",IF(AND(AN2="RR",INT(24*AO2)<24),"< 24 Hrs",INT(24*AO2)))

 

[VBABEGINER]

I have given all the parenthesis..Can one resolve this..Thanks in advance..Cheers.!!

 

[steve the fish]

You are closing your IF statements. Remove the closing ) and place it at the end of the formula.

 

[cunningAce]

Try this,

=IF(AND(AN2="MR",INT(24*AO2)>8),"> 8 Hrs",IF(AND(AN2="MR",INT(24*AO2)<8),"< 8 Hrs",IF(AND(AN2="MRR",INT(24*AO2)>1.5),"> 1.5 Hrs",IF(AND(AN2="MRR",INT(24*AO2)<1.5),"< 1.5 Hrs",IF(AND(AN2="RR",INT(24*AO2)>24),"> 24 Hrs",IF(AND(AN2="RR",INT(24*AO2)<24),"< 24 Hrs",INT(24*AO2)))))))

 

[VBABEGINER]

Can you please re correct above formula, and highlight the change..i really dont understand..

You are closing your IF statements. Remove the closing ) and place it at the end of the formula.

 

[steve the fish]

Go along to your 2nd "8 Hrs". You close the IF. Remove that )

 

[JugglerJAF]

If you "split" your formula onto individual lines by pressing Alt+Return, you get the following:

=IF(AND(AN2="MR",INT(24*AO2)>8),"> 8 Hrs",
IF(AND(AN2="MR",INT(24*AO2)<8),"< 8 Hrs"),
IF(AND(AN2="MRR",INT(24*AO2)>1.5),"> 1.5 Hrs",
IF(AND(AN2="MRR",INT(24*AO2)<1.5),"< 1.5 Hrs",
IF(AND(AN2="RR",INT(24*AO2)>24),"> 24 Hrs",
IF(AND(AN2="RR",INT(24*AO2)<24),"< 24 Hrs",INT(24*AO2)))

This shows that you've got a closing bracket at the end of your second IF statement that shouldn't be there. Delete that, and add the correct number of closing brackets at the end to fix the formula.

 

[snjpverma]

Can you please re correct above formula, and highlight the change..i really dont understand..

=IF(AND(AN2="MR",INT(24*AO2)>8),"> 8 Hrs",IF(AND(AN2="MR",INT(24*AO2)<8),"< 8 Hrs"),IF(AND(AN2="MRR",INT(24*AO2)>1.5),"> 1.5 Hrs",IF(AND(AN2="MRR",INT(24*AO2)<1.5),"< 1.5 Hrs",IF(AND(AN2="RR",INT(24*AO2)>24),"> 24 Hrs",IF(AND(AN2="RR",INT(24*AO2)<24),"< 24 Hrs",INT(24*AO2)))

the text in the formula highlighted above should not include that round bracket there. it should be like this "8 HRS", instead of "8 HRS"),

 

[VBABEGINER]

All the way..silly..i'm.

And Thanks All..

 

[VBABEGINER]

Hello All,
with the same query i have question on formula..

[COLOR=#333333]=IF(AND(AN2="MR",INT(24*AO2)>8),"> 8 Hrs",IF(AND(AN2="MR",INT(24*AO2)<8),"< 8 Hrs",[/COLOR][COLOR=#ff0000]IF(AND(AN2="MRR",INT(24*AO2)>1.5),"> 1.5 Hrs",IF(AND(AN2="MRR",INT(24*AO2)<1.5),"< 1.5 Hrs"[/COLOR][COLOR=#333333],IF(AND(AN2="RR",INT(24*AO2)>24),"> 24 Hrs",IF(AND(AN2="RR",INT(24*AO2)<24),"< 24 Hrs",INT(24*AO2)))))))[/COLOR]

In above formula..condition..which red color highlighted..there I need something like below..
- instead of showing hour i need output in Minutes...example..
if time showing in AO2 = 0.26.26 then "0.30 Min" as output Or somewhere showing 30 Min of gap till 1.5 Hrs. Above 1.5 Hrs will display as a "> 1.5 Hrs"...

Can any one please suggest