Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / January 2004

Tip: Looking for answers? Try searching our database.

Can someone Decipher this Excell Formula for me ???

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andy Yeo - 02 Oct 2003 09:39 GMT
IF(C19<=G2,I2,IF(C19<=G4,(C19-G2)*H3+I2,IF(C19<=G6,(C19-G4)
*H5+I4,IF(C19<=G8,(C19-G6)*H7+I6,IF(C19<=G10,(C19-G8)
*H9+I8,IF(C19<=G12,(C19-G10)*H11+I10,IF(C19<=G14,(C19-G12)
*H13+I12,IF(C19<=G16,(C19-G14)*H15+I14,(C19-G16)
*H17+I16))))))))

if possible can you please convert it to C for me ?

Thanks
M. lane - 04 Oct 2003 23:28 GMT
> IF(C19<=G2,I2,IF(C19<=G4,(C19-G2)*H3+I2,IF(C19<=G6,(C19-G4)
> *H5+I4,IF(C19<=G8,(C19-G6)*H7+I6,IF(C19<=G10,(C19-G8)
> *H9+I8,IF(C19<=G12,(C19-G10)*H11+I10,IF(C19<=G14,(C19-G12)
> *H13+I12,IF(C19<=G16,(C19-G14)*H15+I14,(C19-G16)
> *H17+I16))))))))

This is a simple cell reference formula which can only be understood by
looking at the worksheet from which it came.
From what I see right off hand, there are 8 test's that this formula is told
to perform in sequence;
Test 1 is: IF(C19<=G2,I2
IF the content in cell C19 is less than or equal to the content in cell G2,
then post the content of cell I2 here (in the cell where you got this
formula), otherwise, perform the next test and so on.
Without looking at the entire sheet, it is highly unlikely you will be able
to figure out what the worksheet or formula is written for because it
performs several mathematical equations which can be used for just about
anything.

> if possible can you please convert it to C for me ?
>
> Thanks
Mark Henri - 28 Jan 2004 19:30 GMT
> IF(C19<=G2,I2,IF(C19<=G4,(C19-G2)*H3+I2,IF(C19<=G6,(C19-G4)
> *H5+I4,IF(C19<=G8,(C19-G6)*H7+I6,IF(C19<=G10,(C19-G8)
[quoted text clipped - 3 lines]
>
> if possible can you please convert it to C for me ?

/* should be something like this--*/
/* declare all variable as double */
double result;

if (C19<=G2) {
  result = I2;
} else if (C19<=G4) {
  result = (C19-G2)*H3+I2;
} else if (C19<=G6;
  result = (C19-G4)*H5+I4;
} else if (C19<=G8) {
  result = (C19-G6)*H7+I6;
} else if (C19<=G10) {
  result = (C19-G8)*H9+I8;
} else if (C19<=G12) {
  result = (C19-G10)*H11+I10;
} else if (C19<=G14) {
  result = (C19-G12)*H13+I12
} else if (C19<=G16) {
  result = (C19-G14)*H15+I14;
} else {
  result = (C19-G16)*H17+I16;
}
Mark Henri - 29 Jan 2004 17:04 GMT
On looking at it, my solution isn't right but you get the idea.  Note that
Excel only allow 7 nested if's.

Mark
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.