View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

did you enter
....360(H2,X1...
or ...360(date(H2),X1...

Why are you using the ...Sum...


"Bill R" wrote:

=IF(ISBLANK(Dec!E2),YTD!F12,(IF(ISERROR(SUM(((F32)/(DAYS360(DATE(2005,1,1),X1,FALSE)))*(360))*(F13)), "",(SUM((F32)/(DAYS360(DATE(2005,1,1),X1,FALSE))))*(360))*(F13)) )

This is my formula, and it works but instead of entering the date (2005,1,1)
manually I want it to pull from cell (H2) but when I reference (H2) I get an
error message telling me that I have too many arguments. How can I make this
work?