formula in excel

Question

EXAMPLE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;E&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; G&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; H&nbsp;&nbsp; 1&nbsp; &nbsp; &nbsp;NUMB&nbsp; &nbsp; ITEM&nbsp; &nbsp; &nbsp;Name&nbsp; &nbsp; &nbsp; AMT&nbsp; &nbsp; &nbsp; &nbsp;Paid Amt&nbsp; &nbsp; LEFT&nbsp; &nbsp; PAID/UnPaid&nbsp; &nbsp;$/CC/###&nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Shirt&nbsp; &nbsp; &nbsp; &nbsp;JOE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Paid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Cash&nbsp;&nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Shirt&nbsp; &nbsp; &nbsp; Joe&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Unpaid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Shirt&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;Above is an example of an excel spreadsheet I created in Conditional Formatting. Under the F2 Cell and down I used the formula&nbsp;=IF(ISBLANK([@Amount]),"",[@Amount]-[@[Paid Amt]])&nbsp;to only&nbsp; show sum values. I would like to only show paid/unpaid values under the G column in there is a value under the F column. can someone help me with the formula to be able to do that. THANK YOU.&nbsp;

riny_van_eekelen · Answer

JoeTool&nbsp;Created a small table based on your example, believing it does what you ask for. If not, please come back here.&nbsp;

Forum Discussion

formula in excel

Share

Resources