Need help with conditional formatting

[Diane]

Can someone please help with this formula?
=IF(AND(G6="XXX",AR6>1),(SUM(AR6)+60),SUM(AQ6)+60),

I am having problems to enter the last false condition in my formula.

Conditions to be met: G6=XXX, and AR6>1
if true AR6+60
if false go to AQ6>1
if true AQ6+60
if false "-"

 

[Vijay]

Diane,

You can using the formula below. This should work. If not, send me the XLS
and I can try and help.

=IF(AND(G6="XXX",AR6>1),(SUM(AR6)+60),IF(AQ6>1,SUM(AQ6)+60,"-"))

Tx,
Vijay

 

[SteveG]

Assuming you always want to test if G6 = "XXX".

=IF(AND(G6="XXX",AR6>1),SUM(AR6+60),IF(AND(G6="XXX",AQ6>1),SUM(AQ6+60),"-"))


Cheers,

Stev

 

[pinmaster]

Try this:

=IF(AND(G6="XXX",AR6>1),AR6+60,IF(AND(G6="XXX",AQ6>1),AQ6+60,"-"))

HTH
J

 

[Diane]

Thanks this worked out great!

Diane,

You can using the formula below. This should work. If not, send me the XLS
and I can try and help.

=IF(AND(G6="XXX",AR6>1),(SUM(AR6)+60),IF(AQ6>1,SUM(AQ6)+60,"-"))

Tx,
Vijay