Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to create 2 formulas,
I can get this part to work =IF(Q:Q<=5000,Q:Q*I:I,I:I*5000) but I can't phrase the first part so excel can understand what I am trying to accomplish. This first condition (=If I:I is < than or than but not = to 1) must be met before going any further. 1st formula: IF I:I is < than or than but not = to 1, then IF(Q:Q<=5000,Q:Q*I:I,I:I*5000) 2nd formula: IF I:I is not < or but = to 1, then IF(Q:Q<=5000,Q:Q*I:I,I:I*5000) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open Excel 2002 Attachment from Outlook 2002 | Excel Discussion (Misc queries) | |||
Excel 2002: How is the Excel 2007 file format open in Excel 2002 ? | Excel Discussion (Misc queries) | |||
Excel 2002 : Unable to open files in MS Outlook 2002 | Excel Discussion (Misc queries) | |||
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl | Excel Worksheet Functions | |||
Can you print labels using Excel 2002 in a Word 2002 mail merge? | Excel Discussion (Misc queries) |