Thread: Challenge
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OwenGiryluk OwenGiryluk is offline
external usenet poster
 
Posts: 2
Default Challenge

=IF(BG229=0,IF(BE229=3,AK229*(0+Input!$G$10),IF(BE 229=4,AK229*(0+Input!$G$11),
IF(BE229=5,AK229*(0+Input!$G$13),IF(BE229=6,AK229* (0+Input!$G$14),IF(BE229=7,
AK229*(0+Input!$G$15),0))))))

This formula returns a "FALSE" statement if not true. Anyway to change the
formula to return a zero if FALSE. THANKS...