# Need formula to return a desired response

1. ## Need formula to return a desired response

I currently have this formula and it is not working.

=COUNT(I24:U24, I24=0.143,K24=0.285,M24=0.429,O24=0.571,Q24=0.714,S24=0.857,U24=1)

In columns I24:U24 an "x" or "1" can be entered. I am trying to produce a formula that would result in the desired integer noted above. Thus if you place an "x" or "1" in one of the cells I24:U:24 cell X24 would return the corresponding integer. Example: An "X" or "1" in cell M24; would yield in cell X24 0.429. Please help.  Register To Reply

2. ## Re: Need formula to return a desired response

Could you please attach an example of you workbook?

Thanks!  Register To Reply

3. ## Re: Need formula to return a desired response

Might want to change your subject to something more descriptive and also post a sample workbook.  Register To Reply

4. ## Re: Need formula to return a desired response

See attachment and highlighted area  Register To Reply

5. ## Re: Need formula to return a desired response

The Formula for X24

=IF(OR(I24=1,I24="x"),0.143,IF(OR(K24=1,K24="x"),0.285,IF(OR(M24=1,M24="x"),0.429,IF(OR(O24=1,O24="x"),0.571,IF(OR(Q24=1,Q24="x"),0.714,IF(OR(S24=1,S24="x"),0.857,IF(OR(U24=1,U24="x"),1)))))))

Thanks,

RVASQUEZ  Register To Reply

6. ## Re: Need formula to return a desired response

Try this: ``Please Login or Register  to view this content.``  Register To Reply

7. ## Re: Need formula to return a desired response

Thank you soo much!!!!!!  Register To Reply

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1