What if I want the answer to be in Dollars or Percentage.

R

Rahim Jaffer

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
 
R

Rahim Jaffer

Rahim Jaffer said:
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
Click to expand...

Here's the formula
=IF(C3=C27,10%,IF(C3=C28,15%,IF(C3=C31,25%,IF(C3=C29,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
 
F

Fred Smith

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
 
D

Dave Peterson

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
 
D

Dave Peterson

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

Dave said:
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 said:
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
Click to expand...
Click to expand...
 
R

Rahim Jaffer

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 said:
And remember that formatting can't change the value in the cell.

Dave said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
F

Fred Smith

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 said:
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 said:
And remember that formatting can't change the value in the cell.

Dave said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top