Hi,
I'm trying to average a cell that has a formula but i'm getting an error of #DIV/0!
Hi,
I'm trying to average a cell that has a formula but i'm getting an error of #DIV/0!
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Here is the attachment
This formula returns text:
=IF(C18>=95,"5",IF(C18>=90,"4",IF(C18>=85,"3",IF(C18>=80,"2",IF(C18>=74,"1")))))
Change it to this:
=IF(C18>=95,5,IF(C18>=90,4,IF(C18>=85,3,IF(C18>=80,2,IF(C18>=74,1)))))
You could use this instead:
=LOOKUP(C18,{0,74,80,85,90,95},{0,1,2,3,4,5})
Don’t have an account yet? Register yourself now and be a part of our community!