Sum should be 0


D

Dave Peterson

=if(vlookup(...)="","",vlookup(...))

Use your real =vlookup() formula in both spots.
 
Ad

Advertisements

R

roxiemayfield

Would someone please help me on this formula:

=VLOOKUP('Period 1 Week 1'!D11,InTime,2)

If the InTime value is r the sum should equal 0 (but I do not want a 0, just
want the cell to be blank.
 
Ad

Advertisements

T

T. Valko

Not sure what you want! The subject line says: Sum should be 0. Sum of what?

Maybe this:

=IF(VLOOKUP('Period 1 Week 1'!D11,InTime,2)="r","",VLOOKUP('Period 1 Week
1'!D11,InTime,2))
 

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

Top