#1
|
|||
|
|||
Can you have both formula and manual entry in same column?
Hi there, If I have a custom text column that has a formula, can I also do manual entry in specific cells in this same column? Thanks |
#2
|
|||
|
|||
no, but you can put the text in another cell and change your original to check if there is text in the new column and if not run the original formula.
HTH miles |
#3
|
|||
|
|||
Perfect thanks Miles, makes sense, I'll give that a go
|
#4
|
|||
|
|||
Hi miless2111s, could you help me with the formula I would use as I can't sem to get this to work?
|
#5
|
|||
|
|||
Of course. If you have the "trigger" field as Text1 and the display field as Text2 + the formula that you wanted to display in the instance of a blank trigger field was today's date you would use:
IIf([Text1]<>"",[Text1],Date()) This checks to see if Text1 is blank and if it is displays today's date but if it is not blank it displays what ever is in Text1. To adapt to your situation simply replace the field names as required and change date() to your chosen calculation |
#6
|
|||
|
|||
Apologies miless2111s I'm a bit lost, can I be more specific so that I can try and understand better.
Column (Number20) - contains my planned meterage Column (Number19) - contains my meters complete Column (Text 30) - is where I want to see the meterage progress so I use the below formula in column Text 30 - Format([Number19]/[Number20]*100 & "% ","0%") This calculates the correct percentage and format when column 19 has progress, however when is is zero I get #ERROR. And there are columns I want to manually enter hence why I needed a new column. I created (text 21) to be that column. Any help would be appreciated |
#7
|
|||
|
|||
Quote:
iif([number19] = 0,0,your calculation) When you say that you've got text21 to be a manual entry field do you want one of number19, 20 or text30 to be replaced by the contents of text21? If so simply use the "check if [text20] contains something" formula that I provided Or have I misunderstood that you want. |
#8
|
|||
|
|||
Sorry miless2111s it's not working, can I send you screenshots of what I am trying to do, if you are available to help that is?
|
#9
|
|||
|
|||
Happy to help - you can use Imgur to quickly generate an image.
PM sent if you want to share things like email addresses etc. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula to check combinations of values in one column to find match from another column | kong1802 | Excel | 1 | 06-15-2018 05:26 AM |
Is it possible to put a formula in a table column header to define the name of the column? | JacquesW | Excel | 3 | 05-08-2017 08:00 AM |
set formula calc to manual when opening any workbook | johnd23 | Excel Programming | 1 | 03-31-2017 02:29 PM |
force formula calc to manual when opening any workbook | johnd23 | Excel | 1 | 02-27-2017 08:22 PM |
Sequentail Number Each Row Based On Another Column Entry | KramerJ | Excel | 3 | 05-07-2009 11:35 PM |