add 2 cells w/ 2 dec each, total=whole # except if answers is 2.9.

SusanN

Posts: n/a

add 2 cells w/ 2 dec each, total=whole # except if answers is 2.9.

need a formula: 2 cells w/ 2 decimals each, total = whole # except if
answers are between 2.96 - 2.99 range, does not want them to round up to
whole #

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help adding text values	Texas-DC_271	Excel Worksheet Functions	7	January 15th 05 11:14 PM
Convert data type of cells to Text,Number,Date and Time	Kevin	Excel Worksheet Functions	1	December 31st 04 12:57 PM
To safety merge cells without data destroyed, and smart unmerge!	Kevin	Excel Discussion (Misc queries)	0	December 30th 04 07:17 AM
Heps to design Locked/Unlocked cells in protected worksheet	Kevin	Excel Discussion (Misc queries)	0	December 30th 04 07:09 AM
Convert data of cells to any type: Number, Date&Time, Text	Kevin	Excel Discussion (Misc queries)	0	December 30th 04 06:55 AM

All times are GMT +1. The time now is 03:35 AM.

Menu

About Us