Hello.
trying to design a spread sheet to help my calculate body shapes.
I’m struggling with the last part.
See attached sheet, where HWR = height/cube root of weight.
on the sheet I’ve copy and pasted the formula from the research paper.
essentially, if HWB equals X then X needs to be......(an equation)
if HWB equals Y then Y needs to be ....(a different equation)
Ecto.xls
=if(c7<=38.25,0.1,if(c7<40.75,0.463,0.732))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
I didn't understand the calculations needed, but I believe you need a formula like this:
=IF(C7>=40.75;0.732-28.58;IF(AND(C7<40.75;C7>38.25);0.463-17.63;0.1))
So you essentially have it...just nest the ifs and replace English for operators...
IF(LOGIC,TRUE,FALSE)
Multi IF
IF(Logic,TRUE,IF(Logic,TRUE,IF(Logic,TRUE,FALSE)))
You will notice that the nested IF becomes the FALSE of the preceding IF, only one final FALSE comes at the end.
Took a look at what you were playing with... something like this (That is if I read your sheet/formulas right)
Please Login or Register to view this content.
-If you think you are done, Start over - ELeGault
Double (nested) IF would do. Try:
Formula:
Please Login or Register to view this content.
As two of previous answers (first was free of that problem ;-)):
Once you check first condition (like x<some constant and it has shown to be false, then in nested if you dont have to check AND(x>=someconstant, x<other constant) because for sure x>=someconstant
Otherwise in first IF the condition would be true and second if would not execute
Last edited by Kaper; 02-20-2015 at 05:50 AM.
Best Regards,
Kaper
haha - take your pick
I will. thanks all (just going to see how i get on first)
another question on a related note.
if X = 72.27 and the follwing applies
= 07182 + 0.145X - 0.00068X2 + 0.0000014X3
does that become
= = 07182 + 0.14572 - 0.00068722 + 0.0000014723
and, if so, can you get excel to intert a cell vlaue in the middle of a number like the above?
ignore that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks