numbers formulas
end total on row to be blank if one of the formula cells is temp. left blank
Tom
iPad, iPadOS 16
What Badunit meant was to put in cell N2 the formula
=IF(J2="", "", C2*(J2-D2)/100)
12 replies
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.
Maybe something like this?
=IF(COUNTA(B2:F2)=COLUMNS(B2:F2),SUM(B2:F2),"")
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.
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.
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.
This was the result.
Success!!!!! Thank you so much Guys.
..
Deleted - was responding to an old thread and didn't see all the previous responses first
numbers formulas