Menu

Is there a way to...

Search this Thread

Previous Post

Next Post

#1

Report Post

Posted to microsoft.public.excel.worksheet.functions

Arenlor

Posts: n/a

Default

Is there a way to...

What I have set up is this =E2/100 in cell D2, what I want to know is, is
there any way to have it only go up 1 every time E2 reaches another hundred
instead of going up by .01 each time E2 goes up by one?

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 07:36 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement