Thursday, January 29, 2004

the missing dollar riddle.. New riddle.. 3 men go to a hotel. The total cost of the room is 30.00, each man gives the clerk 10.00. The clerk then realizes that he overcharged the men for the room and gives 5.00 to the bell boy to give back to the men, the bell boy doesn't know how to split the 5.00 three ways, so he gives each man back a dollar and keeps two dollars...now where did the last dollar go? I have some curious question in general on this riddle(none of which help me figure out this riddle) why did three men go to a hotel why did they only rent one room and where can I find a hotel with a bell boy that only charges 25.00 for a room any thoughts..I have no answer..got me.. 11:43:52 PM    comment [] trackback [] VBScript or Excel Spreadsheet Formula Help Needed I think I'm losing my mind or something..I know I know how to do this but for some reason this week its beyond my grasp...here is what I'm trying to do, I have an Excel Spreadsheet and the formula in one cell is: =sum(A15*F15) but if the sum of those two cells is NULL then I want to have the cell be blank instead of a number..is that possible? I tried =sumif(A15, ">1", A15*F15) but that didn't work(which makes me think I don't know how to do a SUMIF command in Excel.  So I was thinking that maybe I needed to use a VBScript to make it work correctly..like an IF..THEN Statement or an IFNULL Statement but got lost on how to do that..I haven't used VBScript in so long..any help out there? thanks in advance...... 8:07:06 AM    comment [] trackback []

© Copyright 2004 Julie Wiggins. Last update: 12/23/2004; 1:48:52 PM. Summer Glow created by Soul Karma, re-designed for Radio by Julie Wiggins-ShimmeringEnergyDesigns