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! |
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! |
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! |
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! |
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! |
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! |
All times are GMT +1. The time now is 08:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com