Forum Discussion
dreaves996
Sep 22, 2020Copper Contributor
Calculated Column return wrong value
Hey All,
I have a calculated column that returns a total after information has been entered into a SharePoint list. For some reason it's returning the wrong number. Here's the formula: =ROUND(SUM(([Breakfast In Town]*10)+([Breakfast On the Go]*6)+([Lunch In Town]*15)+([Lunch On the Go]*10)+([Dinner On the Go]*15)+([Dinner In Town]*25)+([Misc. Expense Amount])+(IF(AND([Flying or Driving?]="Flying",[Rental Car?]="No"),([# of Travel Days]*15),"0"))+(IF([Flying or Driving?]="Flying",([# of Travel Days]*10),"0"))+(IF([Rental Car?]="No",(([Distance Driving]*2)*0.575),(([Distance Driving]*2)*0.2)))),-1)
When I test it. I entered "Flying" for the [Flying or Driving?] column, "No" for the [Rental Car?] column, "1" for the [# of Travel Days] and 0 for the the other columns. For some reason my total came up to $30 when it should of came up to $25. What may I be doing wrong?
No RepliesBe the first to reply