Hello I am trying to insert multiple functions into one formula. Here is the info:
In cell E16 I have this formula: =PRODUCT(B11,D16)
B11 has $155 in it
and
D16 has 1.45% in it
Which leads to the cell E16 having a product of 2.2475 in it. Only problem is I want it to round up to 2.25
I tried this formula:
=PRODUCT(B11,D16)+ROUND(E16,2)
But using that I get a "Circular Reference Warning" which makes the contents of the cell to be 0.
Is there a way to fix this?
Bookmarks