The =IF key function
 

I have generated a spread sheet which is based upon water charges,
there is a standing charge amount of 10.50 for domestic customers and a
standing charge amount of 21.50 for business use. through the diferent
customers which are on different worksheets I would like to use the =F
key to establish wether or not the standing charge is Domestic or
Business. is it possible someone could assist me?

The =IF key function
 

Ant

In A1 enter this.

=IF(B1="","",IF(B1=10.5,"Domestic","Business"))

Drag/copy where you wish.


Gord Dibben MS Excel MVP

On 1 Jan 2007 12:09:26 -0800, "Ant" wrote:

I have generated a spread sheet which is based upon water charges,
there is a standing charge amount of 10.50 for domestic customers and a
standing charge amount of 21.50 for business use. through the diferent
customers which are on different worksheets I would like to use the =F
key to establish wether or not the standing charge is Domestic or
Business. is it possible someone could assist me?

The =IF key function
 

Happy New Year Gord,

I shall try this tomorrow evening when I come home,

Many Thanks,

Ant

Gord Dibben wrote:

Ant

In A1 enter this.

=IF(B1="","",IF(B1=10.5,"Domestic","Business"))

Drag/copy where you wish.


Gord Dibben MS Excel MVP

On 1 Jan 2007 12:09:26 -0800, "Ant" wrote:

I have generated a spread sheet which is based upon water charges,
there is a standing charge amount of 10.50 for domestic customers and a
standing charge amount of 21.50 for business use. through the diferent
customers which are on different worksheets I would like to use the =F
key to establish wether or not the standing charge is Domestic or
Business. is it possible someone could assist me?