end total on row to be blank if one of the formula cells is temp. left blank
Tom
iPad, iPadOS 16
Hi Tom,
More information may lead to a solution. A screen shot will help us to understand your overall aim. Do not show personal data. A screen shot of a table with made-up data will help us to see what you see. Please include column letters (A, B, C etc.) and row numbers (1, 2, 3 etc.). What formulas are you using?
Regards,
Ian.
What Badunit meant was to put in cell N2 the formula
=IF(J2="", "", C2*(J2-D2)/100)
Maybe something like this?
=IF(COUNTA(B2:F2)=COLUMNS(B2:F2),SUM(B2:F2),"")
when I hold a stock my P @L is scewd as the total includes the stock bought.
I need if sell is blank then total remains blank until stock is sold.
N2 shows C2*D2
N3 Shows C2*J2-C2*D2
I need N2 to be blank until J2 Is filled.
The /100 just brings the pence to pounds.
Thanks.
This was the result.
N2 =IF(J2="", "", C2*(J2-D2)/100)
I don't get why the division by 100 but that's what it looks like your current formula does to get the numbers that are in column N.
Did the formula I posted not do what you asked?
Instead of full screenshots, you can also capture smaller areas with Shift-Command 4 or Shift-Command 5. It helps concentrate on what's important in your message.
Success!!!!! Thank you so much Guys.
..
Deleted - was responding to an old thread and didn't see all the previous responses first
numbers formulas
