The =IF key function

A

Ant

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?
 
G

Gord Dibben

Ant

In A1 enter this.

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

Drag/copy where you wish.


Gord Dibben MS Excel MVP
 
A

Ant

Happy New Year Gord,

I shall try this tomorrow evening when I come home,

Many Thanks,

Ant
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do i put a cell reference in an If Function? ASAP 2
BSkyB buys O2 and BE broadband businesses from Telefonica 8
How do I perform calculation within IF statement? 3
Concatenating Functions 3
If Statement XP Version 6
Complicated Query - Ranges, Accruals and F/X Rates 1
THE MILLION DOLLAR EXPOSURE 6
To me this is huge, need some assistance 1

Top