Thread: if formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default if formula

Hi

Try this:

=IF(A1="D/S",16.84,IF(A1="Sunday",8.48,IF(A1="Daily",8.06,"" )))

Regards,
Per

On 7 Maj, 00:43, MSKC LLC wrote:
i need a formula that will do the following function: *If A1 equals either
D/S, Sunday, or Daily and write 16.84 for D/S, 8.48 for Sunday, 8.06 for Daily