IF statement Help

Dell / Dell latitude d620
March 27, 2009 at 13:05:43
Specs: Windows XP Professional SP 3, 1.83 GHz, .99GB of Ram
Hey, so i'm having problems with an excel IF statement. Here's the scenario:

See More: IF statement Help

Report •


#1
March 27, 2009 at 13:41:28
I think this works:

With this setup:

          A            B              C
1  Cash for Debt   Cash On Hand      Debt
2     formula       10,000,000    8,000,000

Put this in A2

=IF(B2-3000000>C2,C2,IF(AND(C2>B2-3000000,B2-3000000>0),B2-3000000,0))


Report •
Related Solutions


Ask Question