ExcelBanter - Help with formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help with formula (https://www.excelbanter.com/excel-worksheet-functions/158002-help-formula.html)

Funkyfido

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

Teethless mama

Help with formula

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

"Funkyfido" wrote:

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

All times are GMT +1. The time now is 09:53 AM.