Hi, I implemented TDIST.RT function today. I ran into 1 issue.
Online docs seems to indicate that negative X is ok (docs do not explicitly say it is a problem) while it isn't for TDIST and TDIST.2T (docs explicitly say it is a problem) https://support.microsoft.com/en-us/office/t-dist-rt-function-20a30020-86f9-4b35-af1f-7ef6ae683eda https://support.microsoft.com/en-us/office/tdist-function-630a7695-4021-4853-9468-4a1f9dcdd192 I do not have Excel installed. I had access to Excel via Sharepoint until recently but not now. Google Sheets does not support TDIST.RT. Would someone with Excel installed be able to see what values are returned for T.DIST.RT(-A2,A3) -- same as the example in the Microsoft doc but with a minus in front of A2? My current implementation treats negative X as a positive A by using abs function on X. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
