I have a work sheet
I have a sheet that depending on when a product is delivered it counts how many days are in a pd.
If it is a Saturday product 4-1-09 <-> 4-29-09 there are 4 Saturdays in that time frame.
With the 4 Saturdays I can give credit,
My problem is the false statment, since they don't have a value wont give me the numbers I need.
I kind need a if statement that has more then one false statment
The last IF() statement in each formula is missing "what to do if false" argument... you could put a "" or 0 or other... what do you want returned if all statements are FALSE?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
zero
Where would i put what the false should be?
Please Login or Register to view this content.
You can probably replace the entire last condition with 0 since anything other than the conditions that should return non-zeroes have been exhausted... then essentially any other condition should return 0.
e.g.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks