I need a forumla as follows:

If column A says "W", then enter into column "U" the amount in column "J"

If column A says "H", then enter into column "V" the amount in column "J"

If column A says "S", then enter into column "U" the amount in column "J" divided in half

I'm attaching an example of what I mean.

Jo Ann  Reply With Quote

2. in U2:

=IF(A2="W",J2,IF(A2="S",J2/2,""))

in V2:

=IF(A2="H",J2,"")  Reply With Quote

The formula works great, but can you add one more part in U2?

 If column A2 is W, enter amount in J2, If column A2 is H, enter 0, if column A2 is S, divide column J2 by 2 Many thanks for you help !!! Originally Posted by NBVC in U2:

=IF(A2="W",J2,IF(A2="S",J2/2,""))

in V2:

=IF(A2="H",J2,"")  Reply With Quote

4. Try:

=IF(A2="W",J2,IF(A2="H",0,IF(A2="S",J2/2,"")))  Reply With Quote

PERFECTION !!! Thank you, you've made my day !!

Jo Ann Originally Posted by NBVC Try:

=IF(A2="W",J2,IF(A2="H",0,IF(A2="S",J2/2,"")))  Reply With Quote

#### Posting Permissions

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