Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help .. please
A B C D E
room name sq. ft tile wood carpet 4 living room 125 x 5 dining room 135 x 6 bedroom 110 x 7 bathroom 68 x 8 9 10 tile wood carpet 11 living room 125 12 dining room 135 13 bedroom 110 14 bathroom 68 Hello all, The above section is the data. I would like the end results to be what happens below (section A11:D14). Basically if the above section is marked with a "x", I would like the sq. ft. to show up. Thank you in advance, al619 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help .. please
On Tue, 16 Dec 2008 12:51:01 -0800, al619
wrote: A B C D E room name sq. ft tile wood carpet 4 living room 125 x 5 dining room 135 x 6 bedroom 110 x 7 bathroom 68 x 8 9 10 tile wood carpet 11 living room 125 12 dining room 135 13 bedroom 110 14 bathroom 68 Hello all, The above section is the data. I would like the end results to be what happens below (section A11:D14). Basically if the above section is marked with a "x", I would like the sq. ft. to show up. Thank you in advance, al619 In cell B11, try the following formula: =IF(C4="x",$B4,"") Copy this to the right to C11:D11 and then copy down B11:D11 to B12:D14 Hope this helps / Lars-Åke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|