If statement problem
If the result to the below formula is "0", how can I rewrite this to say "No
Respones"? =IF(C5="APR07",VLOOKUP(C6,APR07!D16:AB600,4,FALSE) ,IF(C5="MAY07",VLOOKUP(C6,MAY07!D16:AB600,4,FALSE) ,IF(C5="JUN07",VLOOKUP(C6,JUN07!D16:AB600,4,FALSE) ,"No Data"))) |
If statement problem
=IF(your_formula=0,"No Respones",your_formula)
-- Gary''s Student - gsnu200717 "Scott@CW" wrote: If the result to the below formula is "0", how can I rewrite this to say "No Respones"? =IF(C5="APR07",VLOOKUP(C6,APR07!D16:AB600,4,FALSE) ,IF(C5="MAY07",VLOOKUP(C6,MAY07!D16:AB600,4,FALSE) ,IF(C5="JUN07",VLOOKUP(C6,JUN07!D16:AB600,4,FALSE) ,"No Data"))) |
All times are GMT +1. The time now is 12:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com