Hi,
Ive got another probably easy one..
This time, basically I want to say..
C2 is money paid
D2 is total price
E2 is Anything owed
So basically I want it to say..if C2 is < D2 then say "Owes Money" if false say "Paid in Full" BUT if C2 is > D2 then say "Has paid too much"
So far ive got..
Logical Test C2<D2 = TRUE
Value if True = Owes Money
Value if False = Paid in Full
but I havent a clue how to make it then go on to say.."however..if C2 is more than D2 then this person has paid too much".
Any help would be great
Thanks
Bookmarks