When I use this formula to calculate total due, the column doesn't show the totals correctly going down.

=IF(D5="Yes",E5+$B$25,E5)

D5 is relative reference and B25 is absolute reference.

2 Date Prepared Tuesday, December 24, 2019 SKU Yes Client Name 5 Garten 6 Leggett 7 Vong 8 Ranper 9 Williams 10 Davis 11 Jackson 12 Garcia 13 Broadnax Totals 15 Item Name 294211 Refrigerator 327064 Microwave 446741 Washer 643081 Dryer 294211 Refrigerator 446741 Washer 306862 Dishwasher 643081 Dryer 446741 Washer Delivery Price Total Due Years Monthly Payment |$1,399.00 |=IF(D5="Yes",E5+$B$25%E5) ! 3 Yes $379.99 IF(logical_test, [value_if_true], [value_if_false]) No $467.99 No $599.99 $1,399.00 No $467.99 Yes $809.99 No $599.99 Yes $467.99 No u www 14