Hi guys,
This is my first post and i'm not particularly advanced at Excel so apologies if this is a stupid question.
I'm using nested IF functions to reduce a large number of bands to a smaller set using the following formula:
=IF(LEFT(D4,1)="<","< 150",IF(LEFT(D4,3)="150","150-300",IF(LEFT(D4,3)="175","150-300",IF(LEFT(D4,3)="200","150-300",IF(LEFT(D4,3)="225","150-300",IF(LEFT(D4,3)="250","150-300",IF(LEFT(D4,3)="275","150-300","NO")))))))
However im stuck at 275 and need to go to 2000!
All help much appreciated
Matt
This is my first post and i'm not particularly advanced at Excel so apologies if this is a stupid question.
I'm using nested IF functions to reduce a large number of bands to a smaller set using the following formula:
=IF(LEFT(D4,1)="<","< 150",IF(LEFT(D4,3)="150","150-300",IF(LEFT(D4,3)="175","150-300",IF(LEFT(D4,3)="200","150-300",IF(LEFT(D4,3)="225","150-300",IF(LEFT(D4,3)="250","150-300",IF(LEFT(D4,3)="275","150-300","NO")))))))
However im stuck at 275 and need to go to 2000!
All help much appreciated
Matt