Excel formula for xls format. Compitability problem....Need help.

pedie

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
The formula below does not work in 2003 excel.
What formula can i use to get same result.

formula is pretty simple. Thanks :): Pedie
'=IF(C2=1,2,IF(C2=2,3,IF(C2=3,4,IF(C2=4,5,IF(C2=5,6,IF(C2=6,7,IF(C2=7,8,IF(C2=8,9,IF(C2=9,10,1)))))))))
 
Sort by date Sort by votes
P45cal, thank you very much, thank you. Amazing, works perfect. Perfect!:):):)

Thanks again.
 
Upvote 0

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
You must log in or register to reply here.

Similar threads

R
  • Solved
Excel VBA Plus Symbol Automatically Getting Added
Replies
3
Views
313
Fluff
Fluff
T
  • Solved
Formula Causes Memory Leak...Sometimes?!? Help me diagnose
Replies
5
Views
321
Tarkemelion
T
D
  • Question Question
Generating Reports in Word Using Data in Excel
Replies
1
Views
408
Dan_W
D
P
  • Solved
single-formula combining of multiple dynamic arrays (VSTACK?)
Replies
4
Views
3K
Plod518
P
G
  • Solved
Retain data format in results
Replies
2
Views
226
goble
G

Forum statistics

Threads
1,224,603
Messages
6,179,850
Members
452,948
Latest member
UsmanAli786

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top