Nested if statement not working

[bryden2008]

In q39 i am trying to write - =if(p39="",0,(j39*2/156),if(o39="eow",(j39*2/156)/2),(j39*2/156)))
and it says i have too many arguments.
Why?

When "eow" (every other week) is chosen, i need to get half of the 2.54 total in that cell.

[Sam Capricci]

you need another parens here =if(p39="",0,(j39*2/156),if(o39="eow",((j39*2/156)/2),(j39*2/156)))

[bryden2008]

Thank you!
I am getting this...
#VALUE!
with this.
=IF(P39="",0,(J39*2)/156),IF(O39="eow",((J39*2/156)/2),(J39*2/156))....and it will not allow that last (3rd) parens in yours....

[Sam Capricci]

you have another issue, your first argument ends. when you write this if(p39="",0,(j39*2/156),if... you ended your first if statement. Your argument is going, if p39 is blank, (then) return 0 (otherwise) multiply j39 by 2 and divide by 156. The rest of the argument stops. You've effectively stopped the calculation. It doesn't know what to do with the rest.

edit: i didn't find it until i tried yours.

[Sam Capricci]

how about this? =if(p39="",0,if(and(p39<>"",o39="eow"),((J39*2/156)/2),(j39*2/156)))
it appears to work in your sheet.

edit: sorry, had to adjust it.

[bryden2008]

ty,
What is the trick to copy and paste, or is that against the rules?

[Sam Capricci]

there is no rule against copy and pasting that I'm aware of. I do it all the time.

[Sam Capricci]

is there a place to do an "and"?

[bryden2008]

Yes, how.
I need it to divide it by 2 if eow is selected....

[bryden2008]

thanks for you help it worked!

[Sam Capricci]

Great! if that solved it for you don't forget to mark the post as solved using the thread tools dropdown at the top of the post.

And if you're so inclined bumping my reputation is always nice, that is how we advance on this forum.