LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Wazza
 
Posts: n/a
Default Help with IF calculation


here is the formual but I keep getting an error can anybody help me
pleassssse! Thanks!


=if(j12<3,"",IF(J12=3,"0.52",If(j12=4,"0.62",If(j1 2=5,"0.67",If(j12=6,"0.72",if(j12=7,"075",if(j12=8 ,"0.78",if(j12=9,"0.81",IF(j12=10,"0.83",IF(j12= 15,"0.90",if(j12=20,"0.95")))))))))))


--
Wazza
------------------------------------------------------------------------
Wazza's Profile: http://www.excelforum.com/member.php...o&userid=16225
View this thread: http://www.excelforum.com/showthread...hreadid=278202

 
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
How do I use a check box to accept a calculation Joejoethecrackman Excel Discussion (Misc queries) 5 March 22nd 05 08:47 PM
Auto Calculation Automatically Turns Off???? Jeff K. Excel Discussion (Misc queries) 2 December 15th 04 01:39 AM
Help on automatically ending a calculation Jim Excel Worksheet Functions 0 November 11th 04 09:42 PM
time-clock calculation dokliver Excel Worksheet Functions 3 October 28th 04 09:07 PM
how do I get a calculation to repeat various number of times? weelittlekim Excel Worksheet Functions 1 October 27th 04 08:13 PM


All times are GMT +1. The time now is 05:46 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"