Thread: "If" formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default "If" formula

=IF(DAY(A2)=26,86.72,"whatever answer you want in the other situations")
--
David Biddulph

"Needing help at new job"
wrote in message ...
I'm trying to set up a spreadsheet to help me with my job. I track/audit
accounts for a man that does private lending. Here is what I'm trying to
do:

I need a formula for "if the date in column A is 26th of each month or
later, I need column E to be a late fee of $86.72"

I really seem to have problems when it comes to the "if" fuction so I
really
appreciate any help.

Thanks,
Heidi