What do these mean and how do they work?

Thank you,

Steven

Steven -

If these are functions, it might mean that you have an add-in installed.

- Mike


"Steven" wrote in message
...
What do these mean and how do they work?

Thank you,

Steven

Hi Steven,

PDIFF and DDIFF are two functions in Microsoft Excel that are used to calculate the difference between two values. Here's a breakdown of what each function does:

1. PDIFF: This function calculates the percentage difference between two values. The formula for PDIFF is:
   
   
   Formula:

   PDIFF = ((New Value - Old Value) / Old Value) * 100 

   For example, if you want to calculate the percentage difference between the values 50 and 75, you would use the formula:
   
   
   Formula:

   PDIFF = ((75 - 50) / 50) * 100 = 50% 

   This means that the new value (75) is 50% higher than the old value (50).
   
2. DDIFF: This function calculates the difference between two dates in days. The formula for DDIFF is:
   
   
   Formula:

   DDIFF = End Date - Start Date 

   For example, if you want to calculate the number of days between January 1, 2021 and January 15, 2021, you would use the formula:
   
   
   Formula:

   DDIFF = 1/15/2021 - 1/1/2021 = 14 

   This means that there are 14 days between the two dates.