Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-11-2021, 05:51 AM
MichaelM2021 MichaelM2021 is offline Can you have both formula and manual entry in same column? Windows 10 Can you have both formula and manual entry in same column? Office 2016
Novice
Can you have both formula and manual entry in same column?
 
Join Date: May 2021
Posts: 6
MichaelM2021 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 05-11-2021, 06:06 AM
miless2111s miless2111s is offline Can you have both formula and manual entry in same column? Windows 7 32bit Can you have both formula and manual entry in same column? Office 2007
Advanced Beginner
 
Join Date: May 2016
Posts: 32
miless2111s is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 05-11-2021, 06:54 AM
MichaelM2021 MichaelM2021 is offline Can you have both formula and manual entry in same column? Windows 10 Can you have both formula and manual entry in same column? Office 2016
Novice
Can you have both formula and manual entry in same column?
 
Join Date: May 2021
Posts: 6
MichaelM2021 is on a distinguished road
Default

Perfect thanks Miles, makes sense, I'll give that a go
Reply With Quote
  #4  
Old 05-13-2021, 07:32 AM
MichaelM2021 MichaelM2021 is offline Can you have both formula and manual entry in same column? Windows 10 Can you have both formula and manual entry in same column? Office 2016
Novice
Can you have both formula and manual entry in same column?
 
Join Date: May 2021
Posts: 6
MichaelM2021 is on a distinguished road
Default

Hi miless2111s, could you help me with the formula I would use as I can't sem to get this to work?
Reply With Quote
  #5  
Old 05-13-2021, 07:39 AM
miless2111s miless2111s is offline Can you have both formula and manual entry in same column? Windows 7 32bit Can you have both formula and manual entry in same column? Office 2007
Advanced Beginner
 
Join Date: May 2016
Posts: 32
miless2111s is on a distinguished road
Default

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
Reply With Quote
  #6  
Old 05-13-2021, 08:20 AM
MichaelM2021 MichaelM2021 is offline Can you have both formula and manual entry in same column? Windows 10 Can you have both formula and manual entry in same column? Office 2016
Novice
Can you have both formula and manual entry in same column?
 
Join Date: May 2021
Posts: 6
MichaelM2021 is on a distinguished road
Default

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
Reply With Quote
  #7  
Old 05-13-2021, 08:50 AM
miless2111s miless2111s is offline Can you have both formula and manual entry in same column? Windows 7 32bit Can you have both formula and manual entry in same column? Office 2007
Advanced Beginner
 
Join Date: May 2016
Posts: 32
miless2111s is on a distinguished road
Default

Quote:
Originally Posted by MichaelM2021 View Post
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
OK, firstly you can avoid the #error by doing a check if Number19 contains 0 so something like
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.
Reply With Quote
  #8  
Old 05-13-2021, 01:04 PM
MichaelM2021 MichaelM2021 is offline Can you have both formula and manual entry in same column? Windows 10 Can you have both formula and manual entry in same column? Office 2016
Novice
Can you have both formula and manual entry in same column?
 
Join Date: May 2021
Posts: 6
MichaelM2021 is on a distinguished road
Default

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?
Reply With Quote
  #9  
Old 05-13-2021, 11:49 PM
miless2111s miless2111s is offline Can you have both formula and manual entry in same column? Windows 7 32bit Can you have both formula and manual entry in same column? Office 2007
Advanced Beginner
 
Join Date: May 2016
Posts: 32
miless2111s is on a distinguished road
Default

Happy to help - you can use Imgur to quickly generate an image.
PM sent if you want to share things like email addresses etc.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Can you have both formula and manual entry in same column? 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
Can you have both formula and manual entry in same column? Sequentail Number Each Row Based On Another Column Entry KramerJ Excel 3 05-07-2009 11:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft