Hello guys, this is my first thread here I hope I can find help here,
The issue that I need a formula in a certain cell to change according to another cell value.
The equation is :
=IF((N2/2)<=5,N2/2,5)
and depending on the other cell value the equation should change to:
=IF((N2/2)<=10,N2/2,10)
I can't attach the file seems there is a problem with the attach icon!
Update:
Now the file is attached, the equations should be in cell O2 depending on values in cell G2
Last edited by krakha; 02-27-2019 at 02:15 PM.
The Attach Icon no longer works.
Select Edit
Then at the bottom, Advanced Settings
Then Manage Attachments
.Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks lots done and updated the main post.Originally Posted by mehmetcik
depending how?
Formula:
Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
I'll explain more,depending how?
Formula:Please Login or Register to view this content.
there should be 3 API classes in cell G2 depending on the class selection the equation in Inspection interval in cell O2 should change *** follows;
API class 1: Inspection interval (O2) should be equals to 1/2 R.L. (N2) or 5 years which is lesser.
API class 2: Inspection interval (O2) should be equals to 1/2 R.L. (N2) or 10 years which is lesser.
API class 3: Inspection interval (O2) should be equals to 1/2 R.L. (N2) or 15 years which is lesser.
I know there should be simple way to do it but my excel skills ain't that there yet, all what I can do is straight forward formulas.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks