Combining IF formulas

**donyc** · 09-08-2010, 03:32 PM

I posted earlier but it seems I have few more scenarios than I thought.. Is there a way to put a formula with below reasononing?

1) if Q1=0 AND Q2=0 and Cost ABS> 1,000 then comment: "W"
2) if Q1=0 AND Q2=0 and Cost ABS< 1,000 then comment: "X"
3) if Q1<>0 and = Q2<>0 irrelevant of the Cost then comment: "Y"
4) if Q1<>Q2 irrelevant of the Cost then comment: "Z"

Thanks so much
-Danny

Please Login or Register  to view this content.

**NBVC** · 09-08-2010, 03:47 PM

Try perhaps:

=IF(B2<>C2,"Z",IF(B2+C2=0,IF(ABS(D2)>1000,"W","X"),"Y"))

**gmahlert** · 09-08-2010, 03:48 PM

Hello Donyc

put this formula in cell E2 and copy it down.

Please Login or Register  to view this content.

**donyc** · 09-09-2010, 04:13 PM

thanks all for the help.. I edited the formula to:

Please Login or Register  to view this content.

I am having one problem though. It will not let me record the macro.. When I write the code in a cell and press Enter, it gives me error> "Unable to Record"

I want to put a macro for one cell then double click the cell so it auto populates the rows below..

Is Choose function not allowed in macros?