Help with formula

C

CB

I have the following inserted as a condition for formatting.
=AND(RIGHT($A1,5)="Total",F1=100)
How can I modify this to format if the value is between 100 and 105?
Thanks,
CB
 
F

FSt1

hi
try this.....
=AND(RIGHT($A1,5)="Total",AND(F1>100,F1<105))
if you want to include 100 and 105 then
=AND(RIGHT($A1,5)="Total",AND(F1>99,F1<106))

reguards
FSt1
 
D

David Biddulph

You don't need the second IF.
=AND(RIGHT($A1,5)="Total",F1>100,F1<105) or
=AND(RIGHT($A1,5)="Total",F1>=100,F1<=105)

[Note that >99 is not the same as >=100, similarly <106 is not the same as
<=105.]
 
Top