need multiple answers from a IF statement

April 23, 2012 at 15:20:14
Specs: Windows 7
I am trying to get the following scenario to work.
if Cell C9 is populated then it would equal cell J9 if not then 0, also if cell C10 is populated it would equal J10, and finally if both C9 and C10 are populated it would add both J9 and J10.

does anyone know if this is capible?


See More: need multiple answers from a IF statement

Report •

#1
April 23, 2012 at 18:35:47
does anyone know if this is capible?

Not as presented.

MIKE

http://www.skeptic.com/


Report •

#2
April 24, 2012 at 00:31:30
Think about what you've asked for...

If C9 were empty and C10 were populated then you want the answer to be both 0 and C10.

Do you see how that is impossible?

Well, I guess if C10 were populated with 0 you get what you, but not because C9 was empty.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
April 24, 2012 at 08:12:40
ok let me try to explain this a little better
in the sheet that i have been trying to create, Cells C - I = monday - sunday. Cells B9 - B14 is a list of equipment that has to be accounted for on diffrent job numbers everyday. Taking just the first two rows of the sheet that i have C9 - I9 and C10 - I10 all have a set drop down list of all the job numbers that are active. cells J9 - J14 are the daily value amounts for each piece of equipment.

so what i want to do is when they choose a job number for the equipment that was used, i want the daily value for the equipment with that same job number for that day to tally up in the final Cell which we'll say is B18.

so if they used the listed equipment on monday (C9) they would select a list item that match the job number from the drop down and it would total $90(J9)in the final cell (B18), if they didnt use that equipipment the charge would be $0 in the final cell (B18). repeate for (C10). also totalling in (B18) which is why i need for the final to add both J9 and J10 if both C9 and C10 have been populated with the drop down job number...

did that help explain or make it worse?


Report •

Related Solutions

#4
April 24, 2012 at 08:56:20
Why isn't B18 simply the total of the values in Column J?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#5
April 24, 2012 at 09:05:18
i tried that but it would give a total of all the equipment wether it was used or not and they want to know what was used and how much the total would be for what is used

Report •

#6
April 24, 2012 at 09:22:08
I'm still confused.

You said: "so if they used the listed equipment on monday (C9) they would select a list item that match the job number from the drop down and it would total $90(J9)in the final cell (B18)"

Doesn't that mean that J9 doesn't show $90 unless C9 was populated from the drop down?

If that's the case, how would totalling Column J include values for days when the equipment easn't used?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question