exp

I’m trying to use EXP function of a squared value. Can’t seem to figure out what I’m doing wrong. The answer should be 0.67 but getting 1.48. Thanks in advance.

Good Morning, I was hoping someone might be able to help me out with the following question: I have built a spreadsheet that generates data on a monthly basis for 100 distinct "blocks" (January through December, vertically oriented, 100 times; the example below features only 2 months for 1 of...

My countIf formula doesn't see to like "< 1 Yr Exp." If I change the data where its looking to lets say "Test" and I change the formula as well, it works fine. so it has to be that I'm using "< 1 Yr Exp." in the formula. < 1 Yr Exp. = (Less then 1 Year expired) =COUNTIFS('CMOP...

Have a query with time values: start times and ending times. for three different individuals. have created exp to come up with the time that has elapsed. (no problem there) created an exp that is to total the times for the three. if the is not 3 sets of numbers the query is not turning in a...

Hi all, I have existing data on the left. I need the outcome shows on right? Not sure how to derive it. Can you guys pls help me out? Thanks! <colgroup><col><col span="2"><col><col span="3"><col><col><col><col><col><col><col span="4"></colgroup><tbody> A B C D E F A B...

Hi...how to make short name in excel exp John Smith to become J. Smith

Hello, I am looking for a formula that it would let me know when the expiration date going to be expired or has expired with the text in the same cell. For example, Cell A1 contains "ISO 13485:2003 (exp. 2/2/2012)". How do I write the formula to let me know when the date has expired but the...

Afternoon all. I have been struggling with this for a while now and I wonder if you can help. I have a userform which enters data to the database, it then creates a folder, renames it then PDF's all of the worksheets into the new folder. The folder and PDF's change file name based on the...