Need formula for subtraction using IF statement

[Sankara Narayanan]

Hi, Today only i joined. i need a help.
The given formula is working but not exactly getting the output.
My requirement is if a-b<60,b-c<60,c-a<60, print values is yes, if else print No.
Can any one help me getting the correct formula for the above requirement.

=(IF(((E6-F6)<C6),"Yes",IF(((F6-G6)<C6),"Yes")))

[ben_hensel]

Generally:

=IF( OR(A - B < 60, B - C < 60, C - A < 60), "Yes", "No")

Specifically:
=IF(OR(E6 - F6 < C6, F6 - G6 < C6, G6 - E6 < C6), "Yes", "No")

Like that?

[alansidman]

=if(and(a-b<60,b-c<60,c-a<60),"Yes","No")

Edit: Obviously Ben and I looked at your criteria differently. One of these two will work depending on your conditions of "Or" or "And."

[Sankara Narayanan]

Can any one please help in this thread?

[martindwilson]

have you tried the sugestions already posted? if you have and they dont work what exactly is not working

[Sankara Narayanan]

Thanks for your immediate reply.
checking with the data.
will confirm you team.

[Sankara Narayanan]

Dear Team,
Thanks for your help.
The given formula is working fine.

[Sankara Narayanan]

hi team,
i want to take the count using the colour for different criteria.
Can any one please help me in getting the data?