Hi,
I am trying to get a result cell to execute a basic formula only if the number in the changing cell is up to 100.
So... For example, if cell B9 has any number from 0 - 100, then I want the results cell (B10) to multiply the number in B9 by 725 and then display the result.
If the number is over 100, or any number other than a number from 0-100, than I want the result cell to display "error" or "value" or "zero" or something to that effect.
Example
B9=3, B10 should display 2175 (725*3)
B9=99, B10 should display 71775 (725*99)
B9=125, B10 should display "Error" "Value" or "0" etc. since the number is over 100.
Would someone kindly help me with the appropriate entry?
Thank you!
Antonia
Last edited by Antonia; 03-19-2010 at 06:10 PM.
Hi Antonia,
In cell B10, you can have
HTH=IF(AND(B9<=100,B9>0),725*B9,"Error")
JeanRage,
You are SO the best in the West. Seriously! You're like my secret excel weapon. Thank you! You should totally be Forum Guru. I am adding to your reputation.
Merci Merci Beaucoup!
Antonia
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks