You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
