Click here for important information about Computing.net.

I have a spreadsheet that is to handle cash flow.... The question is I need a cell to show a negative figure until a cell has a date in it.

Basically cell O2 has a sum in it which is F2 - I2 + N2.

"If P2 is empty, then O2 should show as a negative, until P2 has a date in it."Can someone please send me a formula to do this, as a negative and preferably the cell in red until P2 is has data.

Thank you very much, this is taking too much of my time and help is greatly received,

Ian

Here's one way: In cell O2 enter the formula:

=IF(P2="",-ABS(F2-I2+N2),F2-I2+N2)

To get the cell Red use Conditional Formatting

1) Select your cells - O2

2) On the ribbon click Conditional Formatting

3) Click on New Rules, itâ€™s near the bottom of the dialog box.

4) Click Use Formula to determine which cells to format.

5) Enter the formula: =IF(P2="",TRUE,FALSE)

6) Click on the Format button

7) Select the Fill Tab

8) Select a pretty color

9) Click OK

10) Click OK

MIKE

You are a genius, thank you so very much for your help!!!!!!!!!!!

Sorry, another question with regards to this now. Eg. Column A now has both + & - amounts in them. We would like to do a total sum that collates just the positive amounts, so they are not subtracting from the running total?

Does that make sense?

Thank you Ian

Does that make sense?No.

Post as a separate question with a bit more detail and/or examples of before & after.

MIKE

Ask Your Question

Weekly Poll

Do you think Intel's new hybrid chips will better compete with Apple/ARM?

Yes (14) | ||

No (14) | ||

I don't know (15) |

Discuss in The Lounge

Poll History