| 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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display constant cell value based on another cell value
Hi,
Assume that 18.00 is in cell J1. =IF(E20,$J$1,"") Regards, OssieMac "Blue Bunny" wrote: 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display constant cell value based on another cell value
Try
=IF(E1="","",18) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Blue Bunny" <Blue wrote in message ... 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display constant cell value based on another cell value
Worked like a charm! Thanks!
For my knowledge, what does the "" do in a formula? Blue Bunny "OssieMac" wrote: Hi, Assume that 18.00 is in cell J1. =IF(E20,$J$1,"") Regards, OssieMac "Blue Bunny" wrote: 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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display constant cell value based on another cell value
Thanks for the suggestion. I couldn't get this one to work, but maybe I'm
entering something wrong??? I truly appreciate you taking the time to help. FYI: someone else suggested =IF(E20,$J$1,"") In J1 put 18. This seems to be working well. Blue Bunny "Chip Pearson" wrote: Try =IF(E1="","",18) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Blue Bunny" <Blue wrote in message ... 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! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display constant cell value based on another cell value
Hi again,
The "" is simply nothing. It is the Else part of the formula. The formula in literal terms means if the value in E2 is greater than zero then insert the value in cell $J$1 Else insert "". If you want to insert a character like A then it has to be enclosed in double quotes. By placing the double quotes together with nothing in between then nothing is displayed. Regards, OssieMac "Blue Bunny" wrote: Worked like a charm! Thanks! For my knowledge, what does the "" do in a formula? Blue Bunny "OssieMac" wrote: Hi, Assume that 18.00 is in cell J1. =IF(E20,$J$1,"") Regards, OssieMac "Blue Bunny" wrote: 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! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display constant cell value based on another cell value
Thanks for the explanation. You've been so helpful. I'm in a new job and
utilizing new aspects of Excel - Excel continues to impress me with it's capabilities! Hope I can contact you again when other challenges occur!! Blue Bunny "OssieMac" wrote: Hi again, The "" is simply nothing. It is the Else part of the formula. The formula in literal terms means if the value in E2 is greater than zero then insert the value in cell $J$1 Else insert "". If you want to insert a character like A then it has to be enclosed in double quotes. By placing the double quotes together with nothing in between then nothing is displayed. Regards, OssieMac "Blue Bunny" wrote: Worked like a charm! Thanks! For my knowledge, what does the "" do in a formula? Blue Bunny "OssieMac" wrote: Hi, Assume that 18.00 is in cell J1. =IF(E20,$J$1,"") Regards, OssieMac "Blue Bunny" wrote: 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! |
| Reply |
| 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 | |||
![Blue Bunny[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
