Excel Formula Help

  • Thread starter Thread starter jmilholland
  • Start date Start date
J

jmilholland

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?
 
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))
 
Thank you!

Luke M said:
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!*
Click to expand...
 
Back
Top