View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Blessedx3 Blessedx3 is offline
external usenet poster
 
Posts: 9
Default Help with if statement (more than 7)

Sandy,

The first IF statement works perfectly. Thank you!

"Sandy Mann" wrote:

Perhaps it was something like:

=IF(AR$3=1,AT4,0)+IF(AR$3=2,AT4+AV4,0)+IF(AR$3=3,A T4+AV4+AX4,0)+...........)