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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Long "IF" formula 5
If Condition 14
If formula nesting 3
Averaging based on criteria 5
Formula Question 2
Explain these please 1
Excel Macro: Changing Color of Cell 7
macro Help 3

Back
Top