Posted to microsoft.public.excel.misc

phooey

external usenet poster

Posts: 13

How to make a contingent formula shorter...

I am calculating sick day accrual.
It's cumulative and adds hours each month, to a max of 24 hours.

Here's what I have, and it works:
=IF(B5+C5+D5+E5+F5+G5+H5+I5+J5+K5+L5+M5=24,24,B5+ C5+D5+E5+F5+G5+H5+I5+J5+K5+L5+M5)

I would like to make this shorter.
I've tried using: =IF(B5:M5=24,24,B5:M5), but it errors.

Ideas??

I Know.. if it's not broke don't fix it.
But I know there has to be an easier/shorter way.....

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
Find value in array	Brook6	Excel Worksheet Functions	26	January 30th 07 09:40 PM
Is it possible?	DakotaNJ	Excel Worksheet Functions	25	September 18th 06 09:30 PM
Reusing formula	Tony29	Excel Discussion (Misc queries)	7	September 7th 06 03:34 AM
sumproduct formula too long, & how to use make an 'OR' statement w	creativeops	Excel Worksheet Functions	11	January 24th 06 05:05 PM
how do I make a formula NOT change when the data range is moved?	Alida Andrews	Excel Discussion (Misc queries)	2	January 6th 05 09:02 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us