Spreadsheet Formula Needed

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

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?

NBVC said:

in U2:

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

in V2:

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

Click to expand...

Try:

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

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

Jo Ann

NBVC said:

Try:

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

Click to expand...