Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel If Statements with more than one Solution
How can I put all of three of these if statements into one cell? For
example I want to say if it equals the 1st one than this is true but if it equals the 2nd one than this is true, if it equals the 3rd one than this is true but if it doesnt equal any of them its 0 1st IF statement for J13: =IF(YEAR($G12)=YEAR(J$12),IF(MONTH($G3)=MONTH(J$12 ),(($D4*$E3)*50%)," ")," ") 2nd IF statement for J13: =IF(YEAR($G12)=YEAR(F$8),IF(MONTH($G12)=MONTH(F8), (($D12*$E12)*25%)," ")," ") 3rd IF statement for J13: =IF(YEAR($G12)=YEAR(I$7),IF(MONTH($G12)=MONTH(I$7) ,(($D12*$E12)*25%)," ")," ") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel MS Query multiple select statements | Excel Discussion (Misc queries) | |||
Extract MS Excel Data embedded in MS Word | Excel Discussion (Misc queries) | |||
How to deploy an Excel 2003 solution | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |