Excel IF Function Help Needed Please

  Durko 13:38 15 May 05
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 05

in F4

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

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

Hands-on: Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

Samsung's beautifully designed Galaxy S8 makes for better VR experiences too

47 iPhone camera tips to help you take better photos