x
Solved

Syntax

Posted on 2013-01-21
Medium Priority
218 Views
How can I modify the following to divide by F51?

=IF((ISERROR(PI_Con_Value_2/F40),"-",(PI_Con_Value_2/F40)/F51*Curr_Den_Project))

Thanks...
0
Question by:pdvsa
• 3
• 3

LVL 7

Expert Comment

ID: 38802650
Do you want to divide by F51 after it has been multiplied by Curr_Den_Project?  If So add parenthesis around F51*Curr_Den_Project .

If thats not what you want, please explain in more detail, the order of the calculations you want to happen.
0

Author Comment

ID: 38802801
Raith:

thanks for the response.
Order I need is as follows:
(PI_Con_Value_2/F40)/F51   then * by Curr_Den_Project

thank you
0

LVL 7

Expert Comment

ID: 38802852

It would look like this afterwards assuming there were no syntax errors:

=IF((ISERROR(PI_Con_Value_2/F40),"-",((PI_Con_Value_2/F40)/F51)*Curr_Den_Project))
0

Author Comment

ID: 38802899
Raith:

I do get a syntax.  I think I need to also modify the first part as well?
0

LVL 7

Accepted Solution

RaithZ earned 1600 total points
ID: 38803030
Try this...

=IF(ISERROR(PI_Con_Value_2/F40),"-",((PI_Con_Value_2/F40)/F51)*Curr_Den_Project)
0

Author Closing Comment

ID: 38803267
thanks...
0

LVL 61

Expert Comment

ID: 38803276
I think you're looking for IIF, not IF.  (?)

``````=IIF(ISERROR(Curr_Den_Project * ((PI_Con_Value_2/F40) /F51) ) ,"-", Curr_Den_Project * ((PI_Con_Value_2/F40) /F51))
``````
0

Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.