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

2. in U2:

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

in V2:

=IF(A2="H",J2,"")

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,"")

4. Try:

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

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,"")))

#### Posting Permissions

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