PPRuNe Forums - View Single Post - Urgent Excel help needed PLEASE!!!!

4th December 2007 | 11:24

#4 (permalink)

cdtaylor_nats

Joined: Feb 2003

Posts: 144

Likes: 0

From: Scotland

The simplest way is a nested IF

=IF(A1<=10,5,IF(A1<=20,10,IF(A1<=30,15,20)))

where A1 is the profit percentage. This structure can be changed to allow as many bands as you want.

The structure of the statement is

IF(test,true value, false value)

Reply

0