Solved

I need to update the following formula

Posted on 2014-01-23
4
191 Views
Last Modified: 2014-01-23
I need to update the following formula to return the value it finds in 3/14/01 date format. Right now, its returning the hard number, 41492...

Notice that I am trying to add some text in the same cell.

=IF(Y10="","",WORKDAY(I10,-10-ROUND(Y10/IF(Y10<=1500,175,300),0)))&" (A)"
0
Comment
Question by:wrt1mea
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 33

Expert Comment

by:Rob Henson
ID: 39803503
Try this:

=IF(Y10="","",TEXT(WORKDAY(I10,-10-ROUND(Y10/IF(Y10<=1500,175,300),0))),"mm/dd/yy")&" (A)"

Change the section "mm/dd/yy" to format as required.

Thanks
Rob H
0
 
LVL 1

Author Comment

by:wrt1mea
ID: 39803532
Its saying there are too few arguments for this function...and is placin the cursor between the 2nd and 3rd cursor after ,300),0)))
0
 
LVL 33

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 39803535
I was just checking the brackets on my version that I just copied from the question as I may have got them wrong and I have also spotted something else.

Where Y10 is blank you will end up with the " (A)" section. Do you actually want this or should blank in Y10 result in blank result?

If so, with corrected brackets:

=IF(Y10="","",TEXT(WORKDAY(I10,-10-ROUND(Y10/IF(Y10<=1500,175,300),0)),"mm/dd/yy")&" (A)")

Thanks
Rob
0
 
LVL 1

Author Closing Comment

by:wrt1mea
ID: 39804277
PERFECT! Thank you!
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question