How to Increment a text in a Formula

Microsoft Office Forums

		Microsoft Office Forums > Microsoft Excel > Excel
How to Increment a text in a Formula

Reply

#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

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

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: 949

ArviLaanemets has a brilliant future

ArviLaanemets has a brilliant future

ArviLaanemets has a brilliant future

ArviLaanemets has a brilliant future

ArviLaanemets has a brilliant future

ArviLaanemets has a brilliant future

ArviLaanemets has a brilliant future

ArviLaanemets has a brilliant future

ArviLaanemets has a brilliant future

ArviLaanemets has a brilliant future

ArviLaanemets has a brilliant future

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto-increment numbers	allex011	Excel Programming	2	05-17-2021 12:25 AM
Loop - Row increment	jrt	Excel Programming	1	04-16-2015 01:46 PM
Increment Numbers	Darbsp	Word	3	03-10-2015 05:25 AM
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 07:45 PM.