• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

OT: Need a little excel help

R

RobertE

Senior member
Need a bit more excel help.

Using the vlookup function to fill in prices for my pay sheets. Been working good so far. As such, the company has chenged the pay sheet format slightly. So I need to revise my version.

Anyway, I need to know if it is possible to use a null or blank value. Currently I'm using a "space" for my data point which returns a dollar value. What I'd like to do if possible is not to have to put a bunch of "spaces" all over my paysheet. Basicly, if I leave a certain cell blank (nothing at all in it) the vlookup will return a value say $0.00.

Make sense?
 
I'm thinking:

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

Unless of course you do pay some people $0.00.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top