| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I'm new to Excel,
and am self taught with minimal experience. I was wondering if someone knew
of a better way to perform this formula: =IF(SUM(E5/F5<95),IF(SUM(E5+100)/(F5+1)=95,1,IF(SUM(E5+200)/(F5+2)=95,2,IF(SUM(E5+300)/(F5+3)=95,3,IF(SUM(E5+400)/(F5+4)=95,4,IF(SUM(E5+500)/(F5+5)=95,5,IF(SUM(E5+600)/(F5+6)=95,6,GET TO WORK)))))),0) What I'd like to do is remove the ',get to work' statement and add more if funtions but of course excel won't allw me to nest more than 7. Is there another function I could be using?? I do not know macros, YET, so while I'm not against it, I would like to use an entry I could explain to someone. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
| Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
| Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Threaded Mode
