I have the following formula below:
=IF(OR(AM25:AP25="Medium", AM25:AP25="Low", AM25:AP25="High"), F25, "")
This displays a Value of 0.67 in the context of my spreadsheet
however, when I change the range in the formula (cells) to this:
=IF(OR(AQ25:AT25="Low", AQ25:AT25="Medium", AQ25:AT25="High"), F25, "")
It displays #VALUE! error - error in value....
Please may you advise to why this occurs?
Thanks,
Karo
Last edited by karobonas; 03-01-2011 at 07:24 AM.
Hi,
It looks like that's an array formula, so when you change the ranges in the formula bar you must complete the entry with CTRL+SHIFT+ENTER, not just ENTER. If you do it correctly, Excel will automatically surround the formula with curly braces { }.
You could use this formula instead which would mean that you don't have to worry about the CTRL+SHIFT+ENTER.
Please Login or Register to view this content.
Last edited by Colin Legg; 03-01-2011 at 07:23 AM.
Colin - Thank you,
Much appreciated - works perfectly.
Reagrds,
Karo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks