I'm using Excel to try to do some accounting.
Using IF in the formula, If a client chooses option 1,2 or 3, the answer is
in dollars. If they choose 4 or 5, I want the answer to be in percentage.
What do I have to add in the formula if the answer has to be in Percentage
or in Dollars.

Rahim Jaffer

Something like:

=if(a1<4,$ formula,% formula)

Does that help?

--
Regards,
Fred


"Rahim Jaffer" <Rahim wrote in message
...
I'm using Excel to try to do some accounting.
Using IF in the formula, If a client chooses option 1,2 or 3, the answer is
in dollars. If they choose 4 or 5, I want the answer to be in percentage.
What do I have to add in the formula if the answer has to be in Percentage
or in Dollars.

Rahim Jaffer

"Rahim Jaffer" wrote:

I'm using Excel to try to do some accounting.
Using IF in the formula, If a client chooses option 1,2 or 3, the answer is
in dollars. If they choose 4 or 5, I want the answer to be in percentage.
What do I have to add in the formula if the answer has to be in Percentage
or in Dollars.

Rahim Jaffer

Here's the formula
=IF(C3=C27,10%,IF(C3=C28,15%,IF(C3=C31,25%,IF(C3=C 29,G3-D3,IF(C3=C30,G3-D3)))))

If C3 = C27, C28 or C31, I want the cell to be in Percenile. Now if C3 = C29
or C30, I want the cell to be in dollars. How do I do that so that it does it
automatically?

Rahim Jaffer

You can't have two separate formats for the same cell.

The best you can do is format the cell as a number, with no signs. If this works
for you, then remove the "%" signs from your formula. Then 10% will display as
10.00 and the dollars will display as, say 12,345.00

--
Regards,
Fred


"Rahim Jaffer" wrote in message
...


"Rahim Jaffer" wrote:

I'm using Excel to try to do some accounting.
Using IF in the formula, If a client chooses option 1,2 or 3, the answer is
in dollars. If they choose 4 or 5, I want the answer to be in percentage.
What do I have to add in the formula if the answer has to be in Percentage
or in Dollars.

Rahim Jaffer

Here's the formula
=IF(C3=C27,10%,IF(C3=C28,15%,IF(C3=C31,25%,IF(C3=C 29,G3-D3,IF(C3=C30,G3-D3)))))

If C3 = C27, C28 or C31, I want the cell to be in Percenile. Now if C3 = C29
or C30, I want the cell to be in dollars. How do I do that so that it does it
automatically?

Rahim Jaffer

I used a custom format of:

[3]0.00%;$0.00

and entered this to see this
1 $1.00
1.4 $1.40
2 $2.00
3 $3.00
4 400.00%
5 500.00%

But maybe you really meant:
[<1]0.00%;$0.00

and entered this to see this
.5 50.00%
.75 75.00%
1 $1.00
1.4 $1.40
2 $2.00
3 $3.00
4 $4.00
5 $5.00



Rahim Jaffer wrote:

I'm using Excel to try to do some accounting.
Using IF in the formula, If a client chooses option 1,2 or 3, the answer is
in dollars. If they choose 4 or 5, I want the answer to be in percentage.
What do I have to add in the formula if the answer has to be in Percentage
or in Dollars.

Rahim Jaffer

--

Dave Peterson

And remember that formatting can't change the value in the cell.

Dave Peterson wrote:

I used a custom format of:

[3]0.00%;$0.00

and entered this to see this
1 $1.00
1.4 $1.40
2 $2.00
3 $3.00
4 400.00%
5 500.00%

But maybe you really meant:
[<1]0.00%;$0.00

and entered this to see this
.5 50.00%
.75 75.00%
1 $1.00
1.4 $1.40
2 $2.00
3 $3.00
4 $4.00
5 $5.00

Rahim Jaffer wrote:

I'm using Excel to try to do some accounting.
Using IF in the formula, If a client chooses option 1,2 or 3, the answer is
in dollars. If they choose 4 or 5, I want the answer to be in percentage.
What do I have to add in the formula if the answer has to be in Percentage
or in Dollars.

Rahim Jaffer

--

Dave Peterson

--

Dave Peterson

Here's the formula
=IF(C3=1,10%,IF(C3=2,15%,IF(C5=3,25%,IF(C3=3,G3-D3,IF(C3=4,G3-D3)))))

If C3 = 1,2 or 5, I want the cell to be in Percentile. Now if C3 = 3 or 4, I
want the cell to be in dollars. How do I do that so that it does it
automatically?

Rahim Jaffer

"Dave Peterson" wrote:

And remember that formatting can't change the value in the cell.

Dave Peterson wrote:

I used a custom format of:

[3]0.00%;$0.00

and entered this to see this
1 $1.00
1.4 $1.40
2 $2.00
3 $3.00
4 400.00%
5 500.00%

But maybe you really meant:
[<1]0.00%;$0.00

and entered this to see this
.5 50.00%
.75 75.00%
1 $1.00
1.4 $1.40
2 $2.00
3 $3.00
4 $4.00
5 $5.00

Rahim Jaffer wrote:

I'm using Excel to try to do some accounting.
Using IF in the formula, If a client chooses option 1,2 or 3, the answer is
in dollars. If they choose 4 or 5, I want the answer to be in percentage.
What do I have to add in the formula if the answer has to be in Percentage
or in Dollars.

Rahim Jaffer

--

Dave Peterson

--

Dave Peterson

Did you try Dave's answer? If so, what happened? We'll assume it didn't work,
otherwise you wouldn't be posting back, but we need to know what results you got
before we can help you further.

To repeat, the most likely solution is a custom format of:

[<1]0.00%;$0.00

If that doesn't solve your problem, tell us what range of values G3-D3 has.

--
Regards,
Fred


"Rahim Jaffer" wrote in message
...
Here's the formula
=IF(C3=1,10%,IF(C3=2,15%,IF(C5=3,25%,IF(C3=3,G3-D3,IF(C3=4,G3-D3)))))

If C3 = 1,2 or 5, I want the cell to be in Percentile. Now if C3 = 3 or 4, I
want the cell to be in dollars. How do I do that so that it does it
automatically?

Rahim Jaffer

"Dave Peterson" wrote:

And remember that formatting can't change the value in the cell.

Dave Peterson wrote:

I used a custom format of:

[3]0.00%;$0.00

and entered this to see this
1 $1.00
1.4 $1.40
2 $2.00
3 $3.00
4 400.00%
5 500.00%

But maybe you really meant:
[<1]0.00%;$0.00

and entered this to see this
.5 50.00%
.75 75.00%
1 $1.00
1.4 $1.40
2 $2.00
3 $3.00
4 $4.00
5 $5.00

Rahim Jaffer wrote:

I'm using Excel to try to do some accounting.
Using IF in the formula, If a client chooses option 1,2 or 3, the answer
is
in dollars. If they choose 4 or 5, I want the answer to be in percentage.
What do I have to add in the formula if the answer has to be in
Percentage
or in Dollars.

Rahim Jaffer

--

Dave Peterson

--

Dave Peterson