#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Quote:
Maybe: B3: = "Saving" & ($C$3 - 3) +ROW() , and copy down? |
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 |
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 |