Need Substitute Formula

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

shift-del

Well-known Member
Joined
Aug 28, 2009
Messages
512
Office Version
  1. 365
Platform
  1. Windows
Hi

Since you changed your specification you are probably not sure yourself.
My guess would be:
Code:
=TEXT(MIN(3,A1+1),"000")
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,619
Messages
5,523,940
Members
409,543
Latest member
LaMaqu1na

This Week's Hot Topics

Top