Percentage of Budget used

T

Turki Ben Sumih

Dear Friends,
I have a formula that calculates the following:
Budget paid/budget *100 & "%"
this formula works well but the results give me so much digits !
coud you please Provide me with a formula to remove the digits, i need for
example 98% instead of 98.12121445 % !
Thanks in advance .
 
D

Dale Howard [MVP]

PMO --

Assuming you are using a text field, use the Format function within your
formula, something like this:

Format([Budget Paid]/[Budget]*100,"0") & "%"

Hope this helps.
 
T

Turki Ben Sumih

Dale --
your formula worked very well.
i have a small problem which is when i put 0 in the Budget paid Fiel ,the
result gives me "#ERROR" . So how can i overcome this error , do you have a
formula to hide the "#ERROR" logo ! :) Thanks
--
PMO Specialist


Dale Howard said:
PMO --

Assuming you are using a text field, use the Format function within your
formula, something like this:

Format([Budget Paid]/[Budget]*100,"0") & "%"

Hope this helps.




Turki Ben Sumih said:
Dear Friends,
I have a formula that calculates the following:
Budget paid/budget *100 & "%"
this formula works well but the results give me so much digits !
coud you please Provide me with a formula to remove the digits, i need for
example 98% instead of 98.12121445 % !
Thanks in advance .
Click to expand...
Click to expand...
 
D

Dale Howard [MVP]

PMO --

Do you have experience writing formulas in Excel? If so, how would you trap
a Division By Zero error in Excel? You do it the same way in Microsoft
Project:

IIF([[Budget]=0,0 & "%", Format([Budget Paid]/[Budget]*100,"0") & "%")

Hope this helps.




Turki Ben Sumih said:
Dale --
your formula worked very well.
i have a small problem which is when i put 0 in the Budget paid Fiel ,the
result gives me "#ERROR" . So how can i overcome this error , do you have
a
formula to hide the "#ERROR" logo ! :) Thanks
--
PMO Specialist


Dale Howard said:
PMO --

Assuming you are using a text field, use the Format function within your
formula, something like this:

Format([Budget Paid]/[Budget]*100,"0") & "%"

Hope this helps.




message
Dear Friends,
I have a formula that calculates the following:
Budget paid/budget *100 & "%"
this formula works well but the results give me so much digits !
coud you please Provide me with a formula to remove the digits, i need
for
example 98% instead of 98.12121445 % !
Thanks in advance .
Click to expand...
Click to expand...
Click to expand...
 
T

Turki Ben Sumih

Dale -- My Friend :)
i have small question,
I need a formula to convert the empty Enterprise text to 0. So how can i
convert if the enterprise text blank to zero !!!! Love you ! :)
--
PMO Specialist


Dale Howard said:
PMO --

Do you have experience writing formulas in Excel? If so, how would you trap
a Division By Zero error in Excel? You do it the same way in Microsoft
Project:

IIF([[Budget]=0,0 & "%", Format([Budget Paid]/[Budget]*100,"0") & "%")

Hope this helps.




Turki Ben Sumih said:
Dale --
your formula worked very well.
i have a small problem which is when i put 0 in the Budget paid Fiel ,the
result gives me "#ERROR" . So how can i overcome this error , do you have
a
formula to hide the "#ERROR" logo ! :) Thanks
--
PMO Specialist


Dale Howard said:
PMO --

Assuming you are using a text field, use the Format function within your
formula, something like this:

Format([Budget Paid]/[Budget]*100,"0") & "%"

Hope this helps.




message
Dear Friends,
I have a formula that calculates the following:
Budget paid/budget *100 & "%"
this formula works well but the results give me so much digits !
coud you please Provide me with a formula to remove the digits, i need
for
example 98% instead of 98.12121445 % !
Thanks in advance .
Click to expand...
Click to expand...
Click to expand...
 
D

Dale Howard [MVP]

PMO --

I don't understand. Is this in reference to the formula I wrote in the last
post, or something else? Otherwise, write formula something like this:

IIF([text field]="", 0, other value)

Hope this helps.




Turki Ben Sumih said:
Dale -- My Friend :)
i have small question,
I need a formula to convert the empty Enterprise text to 0. So how can i
convert if the enterprise text blank to zero !!!! Love you ! :)
--
PMO Specialist


Dale Howard said:
PMO --

Do you have experience writing formulas in Excel? If so, how would you
trap
a Division By Zero error in Excel? You do it the same way in Microsoft
Project:

IIF([[Budget]=0,0 & "%", Format([Budget Paid]/[Budget]*100,"0") & "%")

Hope this helps.




message
Dale --
your formula worked very well.
i have a small problem which is when i put 0 in the Budget paid Fiel
,the
result gives me "#ERROR" . So how can i overcome this error , do you
have
a
formula to hide the "#ERROR" logo ! :) Thanks
--
PMO Specialist


:

PMO --

Assuming you are using a text field, use the Format function within
your
formula, something like this:

Format([Budget Paid]/[Budget]*100,"0") & "%"

Hope this helps.




message
Dear Friends,
I have a formula that calculates the following:
Budget paid/budget *100 & "%"
this formula works well but the results give me so much digits !
coud you please Provide me with a formula to remove the digits, i
need
for
example 98% instead of 98.12121445 % !
Thanks in advance .
Click to expand...
Click to expand...
Click to expand...
 
Top