# Using Excel & IF value for date and deposit

Microsoft Office excel 2007 home & stude...
August 16, 2010 at 12:19:34
Specs: Macintosh
 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

See More: Using Excel & IF value for date and deposit

#1
August 16, 2010 at 13:05:01
 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 Formatting1) Select your cells - O22) On the ribbon click Conditional Formatting3) 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 button7) Select the Fill Tab8) Select a pretty color9) Click OK10) Click OKMIKE

Report •

#2
August 16, 2010 at 13:24:03
 You are a genius, thank you so very much for your help!!!!!!!!!!!

Report •

#3
August 16, 2010 at 13:46:30

Report •

Related Solutions

#4
August 16, 2010 at 14:17:30
 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

Report •

#5
August 16, 2010 at 14:26:59
 Does that make sense?No.Post as a separate question with a bit more detail and/or examples of before & after.MIKEhttp://www.skeptic.com/

Report •