Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display constant cell value based on another cell value
I am setting up a time sheet template in Excel 2002. Below is the setup.
Col A Col B Col C Col D Col E Col F Col G Date Task Area Time In Time Out Hours Rate Amount Due 7:00 8:00 1.00 18.00 18.00 18.00 9:15 10:45 1.50 18.00 27.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 18.00 Invoice Total 2.50 18.00 45.00 I am wanting the rate of 18.00 (which is a constant) to only show in Column F if there is a value in Col. E (same line). Can this be done? Thanks for any help provided! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a formula to hide/ display row based on cell value in Exc | Excel Worksheet Functions | |||
Formula won't display as cell set to Constant | Excel Discussion (Misc queries) | |||
display different images based on cell value? | Excel Worksheet Functions | |||
Can I display a cell based on a calculation (eg M(14/2)? | Excel Worksheet Functions | |||
Changing display of decimal value based on the value in the cell | Excel Worksheet Functions |