• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I am still facing the issue

Status
Not open for further replies.

pradeepm

New Member
Please help me in the below formula.

=IF(A3>=1,"1",IF(B3>=1,"1",IF(A4>=1,"3",IF(B4>=2,"3",IF(A5>=1,"6",IF(B5>=3,"6",F(A6>=1,"10",IF(B6>=4,"10",IF(A7>=1,"15",IF(B7>=5,"15",IF(A8>=2,"2",IF(B8>=1,"2",IF(A9>=2,"5",IF(B9>=2,"5",IF(A10>=3,"13",IF(B10>=3,"13",IF(A11>=4,"21",IF(B11>=4,"21",IF(A12>=5,"25",IF(B12>=5,"25",IF(A13>=3,"22",IF(B13>=5,"22",IF(A14>=3,"8",IF(B14>=2,"8",IF(A15>=4,"12",IF(B15>=2,"12",IF(A16>=5,"16",IF(B16>=2,"16",IF(A17>=3,"4",IF(B17>=1,"4",IF(A18>=4,"7",IF(B18>=1,"7",IF(A19>=2,"9",IF(B19>=3,"9",IF(A20>=5,"11",IF(B20>=1,"11",IF(A21>=2,"14",IF(B21>=4,"14",IF(A22>=4,"17",IF(B22>=3,"17",IF(A23>=3,"18",IF(B23>=4,"18",IF(A24>=2,"19",IF(B24>=5,"19",IF(A25>=5,"20",IF(B25>=3,"20",IF(A26>=5,"23",IF(B26>=4,"23",IF(A27>=4,"24",IF(B27>=5,"24"))

I have two different figures in Column "A" and Column "B". I want to apply a single IF formula in which the Result will be a different number mentioned in IF formula.

Attached Excel file with detail explanation.

Regards,
Pradeep

Attachments
 

Attachments

  • IF Function Issue v1.xlsx
    18.3 KB · Views: 0
pradeepm
Yes - we have noticed it.
Please do not duplicate Your thread more.
You should able to wait that You'll get replies.
... Did You give clear rules with that?
... Did You verify Your given results?
This thread is closed now.
 
Status
Not open for further replies.
Back
Top