One more time, more complex
I need a formula that says:
if [cell B] is between 60 and 100, then [cell C]=[Cell B]/√[cell A], BUT if [Cell A] is <60 or >100, then [cell C]=[cell B]/3√[cell A] (that should read cubed root of Cell A)
so appreciative of you who can chew through these. Thanks for your help
Last edited by dan_fash; 04-03-2015 at 03:32 PM.
If A is less than 60 or greater than 100 cube route otherwise square root?
Please Login or Register to view this content.
Please consider adding a * if I helped.
yes, same basic formula, [cell C]=[Cell B]/√[cell A], but cubed root instead of square root if a is less than 60 or greater than 100
I don't particularly like your title. It is borderline not acceptable. See Rule #1 for the forum:
However, I think that this is what you are looking for.
If the value in B1 is between 60 and 100 find the square root of that value and if the value in B1 is not between 60 and 100 look at the value in A1 and if it is less than 60 or greater than 100 take the cube root of the number in A1
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Im sorry you dont' like the title, I do. in fact, need help with a formula that includes a square root.
What I'm trying to do is insert a formula that will apply one of two different formulas, depending on the value of cell A. not just finding the square or cubed root
If cell A is between 60 and 100, I need for cell C to = [Cell B]/√[cell A]
If Cell A is below 60 or above 100, I need cell C to = [Cell B]/3√[cell A]
Possibly this is in more proper excel verbage
if A1 is between 60 and 100, then C1=B1/√A1
if A1 <60 or >100, then C1=B1/3√A1
This, I think, will meet your needs:
Formula:Please Login or Register to view this content.
I see how this should work, however I receive a #VALUE! error when A1 is between 60 and 100Originally Posted by newdoverman
This, I think, will meet your needs:
Formula:Please Login or Register to view this content.
My A1=70, B1=0.44, C1=#value!
A2=50, B2=0.40, C2=0.66332
One of your values isn't a number to get the #Value error. Entering the values that you quote as giving an error the result is 0.663325
Quote from the Excel Help file:
"Excel can display this error if your formula includes cells that contain different data types. If error checking for formulas is enabled, the ScreenTip displays "A value used in the formula is of the wrong data type." You can typically fix this problem by making minor changes to your formula."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks