Help with Excel percentages

Solved/Closed
krzykris - Mar 11, 2010 at 03:28 PM
 krzykris - Mar 15, 2010 at 01:07 PM
Hello,

Please bear with me as I a very new to this type of syntax with that said here we go.


I have four date columns in Excel like so:

PROJECTED_CHECK_OUT_DATE   ACTUAL_CHECK_OUT_DATE   CHECK_IN_DATE    PERCENTAGE_STAY
         3/20/2010          3/10/2010                 3/5/2010                 50% 

CHECK_IN_DATE date into hospital, due to medical condition calculate PROJECTED_CHECK_OUT_DATE,
leaves hospital ACTUAL_CHECK_OUT_DATE. Need formula to figure hospitalization stay was only fifty percent of the PROJECTED CHECK OUT DATE if his ACTUAL_CHECK_OUT_DATE is more or less PERCENTAGE_STAY
percentage will change accordingly. ALL HELP IS MOST WELCOMED. Thank you.

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 11, 2010 at 06:31 PM
From what I understood from your question

=IF(A5>B5, (B5-C5)/(A5-B5), "")

you can format this cell to be %age


or you can try this

=IF(A5>B5, 100 *(B5-C5)/(A5-B5), "")
0
Thank you!!!!

Came in Monday morning and u answered with correct formula. Have a great day
0