•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
#CALC! error on Excel
Hi guys,
Help on this would be greatly appreciated.
I would like the column O (RATE) to be blank when there is no value entered in columns K (CWS SIZE) and L (HWS SIZE).
At the moment as you can see in the image, when columns K & L are blank its showing the CALC error in column O.
It's only when a correct value is entered that error message disappears.
Formula:
=MIN(TOCOL(IFS(K7:L7={15;22;28;35;42;54;67;76;89;108},{11.39,11.39;11.68,11.68;11.96,11.96;13.08,15.2;14.02,16.35;15.77,18.22;17.17,19.57;20.62,25.63;24.34,28.59;31.25,36.09}),2))
I'm sure it's a simple fix!
Many thanks,
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#rows.com
#Excel alternatives for data analysis
#AI formula generation techniques
#CALC error
#Excel
#column O
#RATE
#column K
#column L
#CWS SIZE
#HWS SIZE
#MIN
#TOCOL
#IFS
#formula
#value
#blank
#error message
#correct value