If statement

D

Donna

I need a formula that will help me produce the correct answer in this
scenario: If Revised forecast is <0 then Forecast - Actual, if Revised
Forecast is >0 then Revised Forecast - Actual

Forecast
360

Revised Forecast
600

Actual
10

Variance
590

This formula is not working -
=IF(D13<"0",SUM(D4-D22),IF(D13>"0",SUM(D13-D22)))
 
D

Donna

Just to complicate things.

If there is no revised forecast how can I modify this formula to return the
original forecast?

Forecast
Can one formula handle either situation?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Formula uses previous saved spreadsheet data! 4
Advanced Filter used with merged cells? 3
DIV/0 error 5
nested If Sumproduct #VALUE! problem 0
Complex SUMPRODUCT/VLOOKUP/SUMIF 1
IF function 3
SUMIF anomaly - Help Needed 2

Top