LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FJM FJM is offline
external usenet poster
 
Posts: 3
Default How do I shorten an IF formula?

How do I shorten this formula. It is missing information from the missing
rows, but if I put those in, it tells me "The specified formula cannot be
entered because it contains more values, references and/or names than are
allowed in the current file format."

Here is the formula...
=IF($F70,IF($G7=0,J7),0)+IF($F80,IF($G8=0,J8),0) +IF($F90,IF($G9=0,J9),0)+IF($F100,IF($G10=0,J10) ,0)+IF($F110,IF($G11=0,J11),0)+IF($F120,IF($G12= 0,J12),0)+IF($F130,IF($G13=0,J13),0)+IF($F140,IF ($G$14=0,J14),0)+IF($F$150,IF($G$15=0,J15),0)+IF( $F$160,IF($G$16=0,J16),0)+IF($F$170,IF($G$17=0,J 17),0)+IF($F$180,IF($G$18=0,J18),0)+IF($F$190,IF ($G19=0,J19),0)+IF($F200,IF($G20=0,J20),0)+IF($F2 10,IF($G21=0,J21),0)+IF($F220,IF($G22=0,J22),0)+ IF($F230,IF($G23=0,J23),0)+IF($F240,IF($G24=0,J2 4),0)+IF($F250,IF($G25=0,J25),0)+IF($F260,IF($G2 6=0,J26),0)+IF($F270,IF($G27=0,J27),0)+IF($F$330 ,IF($G$33=0,J33),0)+IF($F$370,IF($G$37=0,J37),0)+ IF($F$380,IF($G$38=0,J38),0)+IF($F$390,IF($G$39= 0,J39),0)+IF($F$400,IF($G$40=0,J40),0)+IF($F$410 ,IF($G$41=0,J41),0)+IF($F$420,IF($G$42=0,J42),0)+ IF($F$430,IF($G$43=0,J43),0)+IF($F$440,IF($G$44= 0,J44),0)

Can anyone help me out, I hope?! Please?! Thank you!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Shorten a formula Jeze77 Excel Discussion (Misc queries) 0 August 30th 07 07:46 PM
Shorten a formula Jeze77 Excel Discussion (Misc queries) 6 August 30th 07 06:34 PM
Shorten Formula Lemmesee Excel Worksheet Functions 3 January 7th 07 10:30 PM
Shorten a Formula Kevin Excel Worksheet Functions 4 January 30th 06 02:31 AM
Trying to shorten (or use new) formula Monk Excel Discussion (Misc queries) 1 June 29th 05 06:23 PM


All times are GMT +1. The time now is 04:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"