Help with formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=IF(H45<0,"",IF(AND(H45<$B$1,A45<>207003),($B$1-H45)/(H45-G45)*I45,($B$1-H45-($B$1-H45)/7)*2))
 
Back
Top