View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Funkyfido Funkyfido is offline
external usenet poster
 
Posts: 18
Default Help with formula

I am looking for help with the following formula

=IF(AND(H45<$B$1,A45<207003),($B$1-H45)/(H45-G45)*I45,($B$1-H45-($B$1-H45)/7)*2)

I want to have something else onto the formula which says that if the entry
is less than 0 then enter ""

Any ideas?
Thanks