Formula help

S

sunnydazy

I need a formula for an either/or situation
if the value of the cell in E1 is one then add the value of J1 to the cell J5
or if the value of the cell in E1 is two then add the value of J to the cell
J6.
any help would be appreciated. I've tried everything I could think of.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula problem 3
Formula problems 4
Subtotal and IF Formula 1
How to set cell value to emptry if three other columns are empty too 1
Excel 2007 storing the high and low 3
Set add function ignore #N/A 1
formula to add the highest value 5
Formula adding 2 days... 2

Top