search sponsored by:
Advanced Search

The Green Industry's Resource Center

Old 02-20-2005, 11:10 AM
ksland's Avatar
ksland ksland is offline
LawnSite Senior Member
Join Date: Mar 2001
Location: Cape Cod, Ma
Posts: 927
Excel Question

Is there a way to enter a value in a cell that has a formula attached to it WITHOUT it being part of the calculation. Say Cell A3 has the formula A1*A2 and I want to enter text into A2 and have it treat it like a zero or not recognize it all together.
Reply With Quote
Old 02-20-2005, 02:38 PM
Critical Care's Avatar
Critical Care Critical Care is offline
LawnSite Bronze Member
Join Date: Nov 2003
Location: Central Oregon
Posts: 1,654
Look at the attached file. From A3-A8 is a combination of numeric and text values. By using the IF function you can create another column where all text values give you a 0 value. Now you can add, multiply, or do whatever you want to with this new column. - Bruce
Attached Files
File Type: zip (1.4 KB, 20 views)
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Layout Style:

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.
Copyright ©1998 - 2012, LawnSite.comô - Moose River Media
All times are GMT -4. The time now is 11:58 AM.

Page generated in 0.06015 seconds with 9 queries