Excel Formula Help
 

I am trying to write a formula contained in cell V5 of my spreadsheet as
follows: =F5-(F5*C5)+T5). However what i want to also include is if the
value returned in V5 = T5 replace with "0.0000" how do i do that?

Excel Formula Help
 

Hi,

=if(F5-(F5*C5)+T5=T5,"0.0000",F5-(F5*C5)+T5)

"jmilholland" wrote:

I am trying to write a formula contained in cell V5 of my spreadsheet as
follows: =F5-(F5*C5)+T5). However what i want to also include is if the
value returned in V5 = T5 replace with "0.0000" how do i do that?

Excel Formula Help
 

The formula you posted is missing a parenthesis somewhere. I will make an
assumption regarding its placement...
=IF(F5-((F5*C5)+T5)=T5,0,F5-((F5*C5)+T5))

And format cell to display 4 decimals. If you don't want to format the cell
to 4 decimals and don't mind have a text string returned, you could change
formula to:
=IF(F5-((F5*C5)+T5)=T5,"0.0000",F5-((F5*C5)+T5))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"jmilholland" wrote:

I am trying to write a formula contained in cell V5 of my spreadsheet as
follows: =F5-(F5*C5)+T5). However what i want to also include is if the
value returned in V5 = T5 replace with "0.0000" how do i do that?

Excel Formula Help
 

Thank you!

"Eduardo" wrote:

Hi,

=if(F5-(F5*C5)+T5=T5,"0.0000",F5-(F5*C5)+T5)

"jmilholland" wrote:

I am trying to write a formula contained in cell V5 of my spreadsheet as
follows: =F5-(F5*C5)+T5). However what i want to also include is if the
value returned in V5 = T5 replace with "0.0000" how do i do that?

Excel Formula Help
 

Thank you!

"Luke M" wrote:

The formula you posted is missing a parenthesis somewhere. I will make an
assumption regarding its placement...
=IF(F5-((F5*C5)+T5)=T5,0,F5-((F5*C5)+T5))

And format cell to display 4 decimals. If you don't want to format the cell
to 4 decimals and don't mind have a text string returned, you could change
formula to:
=IF(F5-((F5*C5)+T5)=T5,"0.0000",F5-((F5*C5)+T5))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"jmilholland" wrote:

I am trying to write a formula contained in cell V5 of my spreadsheet as
follows: =F5-(F5*C5)+T5). However what i want to also include is if the
value returned in V5 = T5 replace with "0.0000" how do i do that?