Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 03:12 PM.


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