|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
12-06-2007, 09:50 AM
|
|||
|
|||
|
divide the final value
Hello all,
I have a forumla that works fine but I need to divide the final value. This works fine: =(TLP!C23)-(TLP!C23*$AD$18%)+($B$15*A17/1000000*$AD$19) But when I add the divide part at the end it doesnt work =(TLP!C23)-(TLP!C23*$AD$18%)+($B$15*A17/1000000*$AD$19)/$AD$17 if I change the '/' to '+' the foruma works, just not with '/' Very confused lol Cheers, JJ 
|
|
#2
12-06-2007, 10:21 AM
|
||||
|
||||
|
How doesn't it work? Do you get an error message or wrong result?
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge! Please read the Forum Rules: Rules
|
|
#4
12-06-2007, 10:28 AM
|
||||
|
||||
|
Maybe. I don't have 2007 and it works...Perhaps there is a setting that has been change to disallow that character as a divisor?
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge! Please read the Forum Rules: Rules
|
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
