IF Percentage

[dgavin]

How do I write the following in a formula ?

In D19

If D18 = "A" and C18 + C19 is less than 92% then "A" if not then blank.

C18 and C19 are percentages by the way.

Thanks

 

[VoG]

Try

=IF(AND(D18="A",C18+C19<0.92),"A","")

 

[kidwispa]

How do I write the following in a formula ?

In D19

If D18 = "A" and C18 + C19 is less than 92% then "A" if not then blank.

C18 and C19 are percentages by the way.

Thanks

Try

=IF(AND(D18="A",(C18+C19)<0.92),"A","")

 

[dgavin]

HI the formula works great for one cell but when I copy it down the column is dosent work.

For instance I tried changing it to this

=IF(AND(D24="A",C18:C25<0.92),"A","")

but it still didn't work, but when tried this

=IF(AND(D25="A",C18+C19+C20+C21+C22+C23+C24+C25<0.92),"A","")

it worked. Its not ideal is there a simpler solution instead of choosing individual cells ?

 

[VoG]

Try

=IF(AND(D24="A",SUM(C18:C25)<0.92),"A","")