Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-19-2022, 01:38 PM
bil_san1 bil_san1 is offline How to Increment a text in a Formula Windows 10 How to Increment a text in a Formula Office 2016
Novice
How to Increment a text in a Formula
 
Join Date: Oct 2022
Posts: 12
bil_san1 is on a distinguished road
Default How to Increment a text in a Formula

Hi,



Please guide me how to change B4 to Saving2 and B5 to Saving3 and so on.....

=IF(C3>=1,"Saving1","")



Thanks.
Reply With Quote
  #2  
Old 10-20-2022, 01:54 AM
ArviLaanemets ArviLaanemets is offline How to Increment a text in a Formula Windows 8 How to Increment a text in a Formula Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by bil_san1 View Post
Please guide me how to change B4 to Saving2 and B5 to Saving3 and so on.....
?
Maybe:
B3: = "Saving" & ($C$3 - 3) +ROW()
, and copy down?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-increment numbers allex011 Excel Programming 2 05-17-2021 12:25 AM
How to Increment a text in a Formula Loop - Row increment jrt Excel Programming 1 04-16-2015 01:46 PM
Increment Numbers Darbsp Word 3 03-10-2015 05:25 AM
How to Increment a text in a Formula on click increment gsrikanth Excel Programming 1 02-23-2012 08:19 AM
Increment Numbers Help Jazz43 Word 2 07-30-2010 02:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:56 AM.


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