-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
e18
-
K
Sum formula not working
Hi, I am facing a weird challenge here. I have a column in with I have ifand conditions and the corresponding result is a number. Please see the formula I am below:- Formula 1 =IF(C16="Yes","5",IF(C16="No","0")) Formula 2...- karthik_kaliappan
- Thread
- e18 formula number numbers result
- Replies: 5
- Forum: Excel Questions
-
A
Time Input EXCEL 2003
Time Input In cell F1 I have the following formula =TEXT(HOUR(NOW()),"00")&":"&TEXT(MINUTE(NOW()),"00")&":"&TEXT(SECOND(NOW()),"00") Which displays the current time. Formatted as General. I would like to enter a number in cell E18, and have D18 Display the time from F1, which auto updates...- adulted
- Thread
- d18 e18 input number time
- Replies: 1
- Forum: Excel Questions
-
E
Leaving a cell blank if another cell is blank
Formula in E19 is, E16 - E18. I also want, if E18 is blank that E19 will be blank. Thanx to the Excel World for your help. Brian- excel on the run
- Thread
- blank cell e18 e19 excel
- Replies: 3
- Forum: Excel Questions
-
R
Formula assistance nested If's/or
I can't seem to get this to work. Should be easy but I'm not getting the result I want If $B18 is blank OR I enter a value of 0 in $E18 I want $G18 to be "No" otherwise $G18 will be the value that is in entered in $B18 Right now it works without out the layer of $E18. This works...- Rockerdo
- Thread
- $e18 $g18 blank e18 works
- Replies: 2
- Forum: Excel Questions
-
R
conditional Formatting Help
I hope I am able to explain what I am looking to do.... I would like to use conditional Formatting in a table where there is a value in cell E18 and a value in D18. I would like the value in E18 to turn red if the value in D18 is 3% or more than the value in E18. If the value in D18 is not 3%...- Repoort
- Thread
- cell conditional d18 e18 turn
- Replies: 4
- Forum: Excel Questions
