Help with formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Funkyfido - 12 Sep 2007 14:10 GMT

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

Reply to this Message

Teethless mama - 12 Sep 2007 14:32 GMT

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

> I am looking for help with the following formula
>
[quoted text clipped - 5 lines]
> Any ideas?
> Thanks

Reply to this Message