View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mcmilja mcmilja is offline
external usenet poster
 
Posts: 35
Default Need help with If statement

Hello,

I need help with a nested if statement. How would I build the statement
using the following logic: If cell B2 = 2, then add text "00" to the front
of what's in cell A2 (="00"&A2).

SDF Character Result
A2: 63 B2:2 C2:0063

Thanks!
Jaret