Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

Syntax

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
pdvsa
Asked:
pdvsa
  • 3
  • 3
1 Solution
 
RaithZCommented:
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
 
pdvsaProject financeAuthor Commented:
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
 
RaithZCommented:
Then add parenthesis around (PI_Con_Value_2/F40)/F51

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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
pdvsaProject financeAuthor Commented:
Raith:

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

=IF(ISERROR(PI_Con_Value_2/F40),"-",((PI_Con_Value_2/F40)/F51)*Curr_Den_Project)
0
 
pdvsaProject financeAuthor Commented:
thanks...
0
 
mbizupCommented:
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))

Open in new window

0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now