Spreadsheet: 165462d1341239275-if-statement-solution-required-sample
Sheet: Sheet1

 |  |  | Organisation Type | Price
 |  |  |  |  |  |  |  |  | Small | 15
 |  |  | Small | 15 |  |  |  |  | Medium | 40
 |  |  |  | 15 |  |  |  |  | Large | 250
 |  |  |  | 15 |  |  |  |  | X-Large | 1000
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15 |  |  | I want to be able to set up an automatation corresponding to organisation type.
 |  |  |  | 15 |  |  | When you select a type of organisation, the price should automatically appear.
 |  |  |  | 15 |  |  | E.g if I select Large - the price should change to 250
 |  |  |  | 15
 |  |  |  | 15 |  |  | Please Help !
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15
 |  |  |  | 15