Excel IF Function Help Needed Please

  Durko 13:38 15 May 2005
Locked

I'm stuck with an IF function in Excel can anyone advise me please. I've outlined the cell references below. Pretty certain it's an IF function command.

I've calculated all figures for a debt account worksheet except for:
In cell F4 if the debt balance is more than 0 then Debt Outstanding should appear in the cell otherwise show Debt Clear.


A3 B3 C3 D3
Student Initial Debt Final Debt Parent Cont'bn

E3 F4
Balance Debt Outstanding.


Assistance would be very much appreciated.

Durko

  VoG II 13:42 15 May 2005

in F4

=IF(E3>0, "Debt Outstanding", "Debt Clear")

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?