formatting to divide by 1000

[ammartino44]

Hello. How can I get the format to divide the returned value (from a formula) by 1000? Here is the formula I currently have =IFERROR(INDEX(Q4Forecast!$B$2:$N$149,MATCH(C168,Q4Forecast!$B$2:$B$149,0),MATCH(newPnLdate,Q4Forecast!$B$2:$N$2,0)),"")

Would it be possible to set a format method to change the result without changing the formula? Both ways is fine.

[playaller]

Try this:

Please Login or Register  to view this content.

[ammartino44]

Thanks. Why do I need 3 parentheses after the "0"? I always get confused by the parentheses.

[playaller]

I added a parentheses to the beginning and end of the original formula (not including the if error portion) to enclose the result as a value to divide against so it's not that it has to be 3 parentheses at the end, it's that i had to close what I had opened and i'm not even sure if it was necessary that I did so but I knew it would work. If you break it down you can see that there are 3 at the end because they close the 2 formulas within as well as the pair outside of those that group the formulas together as 1:


1st Open: =IFERROR(
2nd Open: (INDEX <-- I added this one
3rd Open: (Q4Forecast!$B$2:$N$149,
OpenandClosed: MATCH(C168,Q4Forecast!$B$2:$B$149,0),
OpenandClosed: MATCH(newPnLdate,Q4Forecast!$B$2:$N$2,0)
3rd Closed: ) <-- I added this one
2nd Closed: )/1000,
1st Closed: "")