how do I create a function where if this tab says PSS then you need to
calculate A1 * 70% and if the tab instead says Derma then it should be A1 *
80% if it tab is blank, don't calculate anthing.

If by "tab" you mean cell (since the worksheet tabs containing the
worksheet names at the bottom of the window cannot be blank), one way:

=IF(A2="PSS",A1*70%,IF(A2="Derma",A1*80%,""))


In article ,
Caroline wrote:

how do I create a function where if this tab says PSS then you need to
calculate A1 * 70% and if the tab instead says Derma then it should be A1 *
80% if it tab is blank, don't calculate anthing.

Hi McGimpsey,

tab is cell.... my bad. :-)
So you are saying that you can add more than one if. Can you do an if and an
average combined in a function? Just trying to see options.

Thanks.
caroline

"JE McGimpsey" wrote:

If by "tab" you mean cell (since the worksheet tabs containing the
worksheet names at the bottom of the window cannot be blank), one way:

=IF(A2="PSS",A1*70%,IF(A2="Derma",A1*80%,""))


In article ,
Caroline wrote:

how do I create a function where if this tab says PSS then you need to
calculate A1 * 70% and if the tab instead says Derma then it should be A1 *
80% if it tab is blank, don't calculate anthing.

What does "tab" mean? try

=if(a2="pss",.7,if(a2="derma",.8,1))*a1

--
Don Guillett
SalesAid Software

"Caroline" wrote in message
...
how do I create a function where if this tab says PSS then you need to
calculate A1 * 70% and if the tab instead says Derma then it should be A1
*
80% if it tab is blank, don't calculate anthing.

You can't have a blank tab but can return the name of the sheet with
=MID(CELL("Filename",A2),FIND("]",CELL("filename",A2))+1,255)
which you can use to carry out your formula.

"Caroline" wrote:

how do I create a function where if this tab says PSS then you need to
calculate A1 * 70% and if the tab instead says Derma then it should be A1 *
80% if it tab is blank, don't calculate anthing.

I am a bit confused or maybe I confused everyone.
This is what I need. I have cell where I place :
A B C D
example distributor $amount Commission $
1 PSS 100,000 B4 *C1
2 n/a 85,000 C2
3 Avanti 180,000 B5 *C3

RANGE
4 PSS 75%
5 Avanti 90%
6 ASA 75%


"Mike" wrote:

You can't have a blank tab but can return the name of the sheet with
=MID(CELL("Filename",A2),FIND("]",CELL("filename",A2))+1,255)
which you can use to carry out your formula.

"Caroline" wrote:

how do I create a function where if this tab says PSS then you need to
calculate A1 * 70% and if the tab instead says Derma then it should be A1 *
80% if it tab is blank, don't calculate anthing.