Thread: IF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default IF
=IF(N7="A",420,IF(N7="B",288,IF(N7="C",130,IF(N7=" D",126,""))))


"Guey Lan" wrote:

The scenario as follows:-
if N7=A, 420
if N7=B, 288
if N7=C, 130
if N7=D, 126

Appreciate your help!!
Reply With QuoteReply With Quote